pgAdmin - Mailing list 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@mera.ru