how to return the last inserted identity column value

From: <mgould(at)isstrucksoftware(dot)net>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: how to return the last inserted identity column value
Date: 2012-03-08 18:16:24
Message-ID: 20120308111624.c760ddbd7c0975bc4b045766db7d895c.6315342a31.wbe@email16.secureserver.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2012-03-08 18:20:25 Re: how to return the last inserted identity column value
Previous Message mgould 2012-03-08 17:33:36 why no create variable