[ADMIN] SQL Help - Obtaining ID of record INSERTED

[[EMAIL PROTECTED]]

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.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly