Re: Getting OID after Insert

On Wed, Oct 17, 2001 at 11:18:44PM -0400, Bruce Cota wrote:
> Is there a way, in SQL, to access the oid of the row created
> by an immediately preceding insert statement?
>
> e.g.
>
> insert into t (x, y) values (1, 2);
>
> select * from t where oid = <what goes here?>
>
> Thanks for any advice.

Yeah, the is a getlastoid function.

sequences, nextval, currval and lastval are a better bet though.

--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/
> Magnetism, electricity and motion are like a three-for-two special offer:
> if you have two of them, the third one comes free.