pgAdmin3 - create function problem

From: "Yaroslav Ulyanov" <yulyanov(at)mera(dot)ru>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: pgAdmin3 - create function problem
Date: 2003-09-04 08:34:08
Message-ID: 014901c372bf$4f8a9cb0$800ca8c0@meraqms.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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(at)mera(dot)ru

In response to

Responses

  • pgAdmin at 2003-09-04 08:40:45 from Yaroslav Ulyanov

Browse pgsql-interfaces by date

  From Date Subject
Next Message Yaroslav Ulyanov 2003-09-04 08:40:45 pgAdmin
Previous Message Yaroslav Ulyanov 2003-09-04 08:20:17 Create function problem