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.