Re: INSERT with RETURNING clause inside SQL function - Mailing list pgsql-general

"Diego Schulz" <dschulz@gmail.com> writes:
> I expected something like this to work, but it doesn't:

> CREATE OR REPLACE FUNCTION add_something(text, text) RETURNS INTEGER AS $$
>    INSERT INTO sometable (id, foo, bar ) VALUES (DEFAULT, $1, $2 )
> RETURNING id ;
> $$ LANGUAGE SQL ;

This case was implemented last week.  In existing release branches
you'll need to use currval or some other workaround to collect the
serial value.

            regards, tom lane