Re: Create function problem

"Yaroslav Ulyanov" <yulyanov(at)mera(dot)ru> writes:

> CREATE FUNCTION "get_new_id1" () RETURNS bigint AS'
> declare
> id bigint;
> begin
> id:=3Dnextval(\'id_sequence\'::text);
> return id;
> end;
> 'LANGUAGE 'sql' VOLATILE ;

That's plpgsql code, but you've declared the function as language 'sql'.

regards, tom lane