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.