On Thu, Mar 8, 2012 at 11:16 AM, <mgould@isstrucksoftware.net> wrote:
> In some languges you can use set l_localid = @@identity which returns
> the value of the identity column defined in the table. How can I do
> this in Postgres 9.1
Assuming you created a table like so:
smarlowe=# create table test (id serial,info text);
NOTICE: CREATE TABLE will create implicit sequence "test_id_seq" for
serial column "test.id"
CREATE TABLE
Then use returning:
smarlowe=# insert into test (info) values ('this is a test') returning id;
id
----
1
(1 row)