Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA03146; Mon, 12 Jul 93 14:49:39 -0700
Message-Id: <9307122149.AA03146@postgres.Berkeley.EDU>
From: David Allan Finch <sarum@vger.demon.co.uk>
Subject: Re: appending aplha...
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Date: Mon, 12 Jul 93 22:44:42 BST

jlee@cs.uml.edu:
> sprintf (buf87, "append y87 ( tri_id = %s, ... )", buf[0], ... ); 
> printf ("\n\nquery is: \n\n%s\n\n", buf87);
> PQexec ( buf87 ); 

did you try

	sprintf (buf87, "append y87 ( tri_id = \"%s\", ... )", buf[0], ... );

but I have not yet tried to place an alpha in a text field,
you could also try the string constant systax (something to do with
: I think)

--
    /		Sarum Wizard
 /\|/\		All Hail Discordia
 | K |		david.finch@vger.demon.co.uk
 \___/		sarum@cix.compulink.co.uk