"Diego Schulz" <dschulz@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general