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 по дате отправления: