"Diego Schulz" <[EMAIL PROTECTED]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general