SQL Help - Obtaining ID of record INSERTED - Mailing list 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 by date:

Previous
From: Chris Hoover
Date:
Subject: Is there anyway to create a functional index using to_date?
Next
From: Bruno Wolff III
Date:
Subject: Re: Is there anyway to create a functional index using to_date?