Hi. I have a table foo(id serial primary key, b int); and I want an insert function create or replace function insert_to_foo(bvalue integer) returns integer as declare newindex integer; begin ... insert into foo (a,b) values (default,bvalue) returning id .... <---- THIS LINE -- do more with newindex here return newindex; end; Well, the problem is that I want the id of the new post to be saved into the newindex variable for further actions. But how do I catch the value into the variable? Should I do: select id from insert into foo (a,b) values (default,bvalue) returning id; ? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general