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

2012-03-08 Thread 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)

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

2012-03-08 Thread 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

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

2012-03-08 Thread 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