Re: Create function problem - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: Create function problem
Date
Msg-id 21879.1062683754@sss.pgh.pa.us
Whole thread Raw
In response to Create function problem  ("Yaroslav Ulyanov" <yulyanov@mera.ru>)
List pgsql-interfaces
"Yaroslav Ulyanov" <yulyanov@mera.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


pgsql-interfaces by date:

Previous
From: Michael Stephenson
Date:
Subject: Re: pgAdmin
Next
From: "Hal Vorlee"
Date:
Subject: XA Resource Manager