SQL Help - Obtaining ID of record INSERTED
От | josh@segrestfarms.com |
---|---|
Тема | SQL Help - Obtaining ID of record INSERTED |
Дата | |
Msg-id | 430255F0.7060500@segrestfarms.com обсуждение исходный текст |
Ответы |
Re: SQL Help - Obtaining ID of record INSERTED
Re: SQL Help - Obtaining ID of record INSERTED Re: SQL Help - Obtaining ID of record INSERTED Re: SQL Help - Obtaining ID of record INSERTED |
Список | pgsql-admin |
Greetings. INSERT INTO orderstemp (customerid,datecreated) VALUES ('5443','8/16/2005 12:00PM') The table orderstemp has a unique identifier field, orderid (of type SERIAL). How can I obtain the orderid of the record inserted in the INSERT INTO statement in postgresql? MSSQL does it like this: INSERT INTO orderstemp (customerid,datecreated) VALUES ('5443','8/16/2005 12:00PM') SELECT @@identity as orderid but this doens't work in postgresql. Any ideas? Thanks in advance.
В списке pgsql-admin по дате отправления: