Re: last inserted raw (identity)

On Fri, Aug 01, 2003 at 04:25:05PM -0700, b b wrote:
>
>  Is there an environment variable that returns the
> primary key of the last inserted row. This is usefull
> if you insert a rwo and need the primary key to insert
> it into another table as a foreign key.
>
>  In MS-SQL that is equivalent to @@identity variable:
>  insert into organization ('org name', ....)
>  insert into contact (@@identity, 'contact name'
> .....)
>  Here Identity is the organization's ID that is needed
> as a foreign key in contact table.

See currval() and nextval().

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato