On Fri, 21 Jun 2002, Bruno Baguette wrote:
> Hello,
>
> I've written a little pl/pgSQL function in order to use it on a little
> postgreSQL database :
>
> CREATE function tuple_add(VARCHAR(200)) RETURNS text AS
> '
> DECLARE
> Response text;
> PeopleName ALIAS FOR $1;
> BEGIN
> INSERT INTO PEOPLES VALUES (SEQUENCE_Id.NEXTVAL(),PeopleName);
I'd suggest:
nextval(''sequence_id'') (or if SEQUENCE_Id was made with double
quotes, nextval(''"sequence_id"'') )