Re: how to return the last inserted identity column value

Hi,

On 9 March 2012 05:20, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Thu, Mar 8, 2012 at 11:16 AM,  <mgould(at)isstrucksoftware(dot)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(dot)ivanic(at)gmail(dot)com)