Horton

Re: SQL-question: returning the id of an insert querry

Alvaro Herrera <alvherre@dcc.uchile.cl>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@dcc.uchile.cl>
To: Scott Chapman <scott_list@mischko.com>
Cc: Martijn van Oosterhout <kleptog@svana.org>, Andreas Fromm <Andreas.Fromm@physik.uni-erlangen.de>, pgsql-general@postgresql.org
Date: 2003-11-10T16:12:59Z
Lists: pgsql-general 
On Mon, Nov 10, 2003 at 08:09:29AM -0800, Scott Chapman wrote:

> Chronological events here:
> 
> X inserts a new record into A.
> Y inserts a new record into A.
> X fetches currval of the SA. What value does X get in this case, the one 
> from X's insert or Y's?

X's.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"¿Qué importan los años?  Lo que realmente importa es comprobar que
a fin de cuentas la mejor edad de la vida es estar vivo"  (Mafalda)