Re: [HACKERS] Get OID of just inserted record - Mailing list pgsql-hackers

On Tue, 2 Nov 1999, Aaron J. Seigo wrote:

> would it be possible to add a RETURN clause to INSERT? e.g.
> 
> INSERT into t1 VALUES('xxx') RETURN oid;
> 
> i could see where this would be useful in many different circumstances.. i
> know this isn't standards compliant, but would be very cool =) i know that with
> triggers, you have access to the current/old/new information, could this be
> harnessed to supply a RETURN facility?

I'm not sure what I'm missing here:

=> insert into foo values (4, 'aaa');
INSERT 7998067 1

This line is generated by libpq's PQcmdStatus(). You can also just get the
oid part by using PQoidStatus(). Is that what you wanted or do you need a
wrapper or binding for a certain environment?
-Peter

-- 
Peter Eisentraut                  Sernanders vaeg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden