Re: [GENERAL] returning oid of last insert?

On Sat, 18 Jul 1998, Matt McClure wrote:

> Is there a way to return the oid of the last insert command?

The protocol does return the oid, as a string. You can see this when using
psql. I'm not sure what libpq function returns this value though.

In JDBC, there isn't an official way, but the 6.4 driver does have a
method to retrieve the oid (It's used internally with the new object
serialization code). Earler versions store the string, but don't use it,
and have no method to retrieve it.

--
Peter T Mount peter(at)retep(dot)org(dot)uk or petermount(at)earthling(dot)net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter(at)maidstone(dot)gov(dot)uk