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 wrote: > On Thu, Mar 8, 2012 at 11:16 AM,   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 lik

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, 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);

[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) T