"Diego Schulz" <dschulz(at)gmail(dot)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