From: Yaroslav Ulyanov <yulyanov@mera.ru>
To: pgsql-interfaces@postgresql.org
Subject: pgAdmin3 - create function problem
Date: Thu, 4 Sep 2003 12:34:08 +0400
Message-ID: <014901c372bf$4f8a9cb0$800ca8c0@meraqms.ru> (raw)
References: <013a01c372bd$5fee1610$800ca8c0@meraqms.ru>
Hello
I cannot write new function with local variables:
CREATE FUNCTION "get_new_id1" () RETURNS bigint AS'
declare
id bigint;
begin
id:=nextval(\'id_sequence\'::text);
return id;
end;
'LANGUAGE 'sql' VOLATILE ;
Error message see when compiling:
ERROR: parser: parse error at or near "bigint" at character 16
That I do wrong?
Best regards,
Yaroslav Ulyanov
yulyanov@mera.ru
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: yulyanov@mera.ru
Subject: Re: pgAdmin3 - create function problem
In-Reply-To: <014901c372bf$4f8a9cb0$800ca8c0@meraqms.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox