[GENERAL] how to return the last inserted identity column value

[mgould]

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 
 
Michael Gould
Intermodal Software Solutions, LLC
904-226-0978


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] how to return the last inserted identity column value

[Scott Marlowe]

On Thu, Mar 8, 2012 at 11:16 AM,  mgo...@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)

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] how to return the last inserted identity column value

[Ondrej Ivanič]

Hi,

On 9 March 2012 05:20, Scott Marlowe scott.marl...@gmail.com wrote:
 On Thu, Mar 8, 2012 at 11:16 AM,  mgo...@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;

You can use lastval() or currval() functions:
http://www.postgresql.org/docs/9.1/static/functions-sequence.html


-- 
Ondrej Ivanic
(ondrej.iva...@gmail.com)

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general