Re: last inserted raw (identity)
От | Ron Johnson |
---|---|
Тема | Re: last inserted raw (identity) |
Дата | |
Msg-id | 1059782548.22384.88.camel@haggis обсуждение исходный текст |
Ответ на | last inserted raw (identity) (b b <hell_wild_hot2@yahoo.com>) |
Список | pgsql-general |
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 | +-----------------------------------------------------------------+
В списке pgsql-general по дате отправления: