returning inserted id - Mailing list pgsql-sql

From Matt A.
Subject returning inserted id
Date
Msg-id 20050821195627.8524.qmail@web35209.mail.mud.yahoo.com
Whole thread Raw
Responses Re: returning inserted id  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-sql
this may have been asked a thousand times but i
haven't found a standard answer...


MSSQL
set nocount on
insert into (column) values (value)
select identityid = @@identity
set nocount off


POSTGRESQL
*cricket cricket* :)


How is this done? By a trigger function? Or is it
natively supported? Could I get an example on how to
do it too? 

Thanks,
Matt

    
____________________________________________________
Start your day with Yahoo! - make it your home page 
http://www.yahoo.com/r/hs 


pgsql-sql by date:

Previous
From: "Matt L."
Date:
Subject: nullif('','') on insert
Next
From: Bernard Henry Voynet
Date:
Subject: Unwanted nested dollar-quoted constants