getting back autonumber just inserted - Mailing list pgsql-sql

From mail TechEvolution
Subject getting back autonumber just inserted
Date
Msg-id 42CD6B58.6060508@techevolution.be
Whole thread Raw
Responses Re: getting back autonumber just inserted
Re: getting back autonumber just inserted
List pgsql-sql
hello

i ame a newbie to PostGreSQL, I ame using PostGreSQL 8.0 
(windowsinstaller) on a xp prof platform

i would like to get back the autonumber from the last record inserted, 
for other SQL db (m$ sql db ...) i could use:
SELECT @@ IDENTITY

can someone help me by informing me what the SQL syntax is to be used 
with PostGreSQL db and get the same result, the last autonumber inserted?

greeTz

wes


pgsql-sql by date:

Previous
From: Tony Wasson
Date:
Subject: Re: left joins
Next
From: Alvaro Herrera
Date:
Subject: Re: getting back autonumber just inserted