Received: from vpcit.ru (qmailr@dialup.vpcit.ru [195.38.52.246]) by hub.org (8.10.1/8.10.1) with SMTP id e7IE9Um87704 for ; Fri, 18 Aug 2000 10:09:31 -0400 (EDT) Received: (qmail 14138 invoked from network); 18 Aug 2000 14:08:12 -0000 Received: from nt3.vpcit.ru (195.38.52.236) by dialup.vpcit.ru with SMTP; 18 Aug 2000 14:08:12 -0000 Date: Fri, 18 Aug 2000 20:07:11 +0600 From: Yury Don X-Mailer: The Bat! (v1.44) Reply-To: Yury Don X-Priority: 3 (Normal) Message-ID: <638911580.20000818200711@vpcit.ru> To: pgsql-sql@postgresql.org Subject: Re: sequences in functions In-reply-To: References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200008/175 Hello Graham, Friday, August 18, 2000, 6:24:15 PM, you wrote: GV> I am having problems referencing sequeces in a function, I think because of GV> the '' characters. The function I am creating is a follows: - GV> CREATE FUNCTION InsertClient ( varchar, varchar, varchar, varchar, varchar, GV> varchar ) RETURNS int4 AS ' GV> DECLARE GV> id INT; GV> BEGIN GV> SELECT nextval('client_seq') INTO id; GV> INSERT INTO client (client_id, last_name, address1, country) GV> VALUES (id, $1, $2, $3); GV> INSERT INTO client_card (client_card_id, type, number, expiry_date, GV> client_id) GV> VALUES (nextval('client_card_seq'), $4, $5, $6, id); GV> RETURN id; GV> END; GV> ' LANGUAGE 'plpgsql'; GV> And the error message is GV> ERROR: parser: parse error at or near "client_seq" GV> EOF GV> Is this because of the ' ' ??? You must to use two quotes: SELECT nextval(''client_seq'') INTO id; -- Best regards, Yury mailto:yura@vpcit.ru