Re: last inserted raw (identity)

On Fri, 2003-08-01 at 18:25, 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.

Why "environment variable"?  Are you writing this in shell?

--
+-----------------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net             |
| Jefferson, LA  USA                                              |
|                                                                 |
| "I'm not a vegetarian because I love animals, I'm a vegetarian  |
|  because I hate vegetables!"                                    |
|    unknown                                                      |
+-----------------------------------------------------------------+