Re: OID stuff - Mailing list pgsql-novice

From Josh Berkus
Subject Re: OID stuff
Date
Msg-id 200301291517.11840.josh@agliodbs.com
Whole thread Raw
In response to OID stuff  (Derek Clarkson <dhc@bigpond.net.au>)
Responses Re: OID stuff
List pgsql-novice
Derek,

> In Postgres, I have to use the 'get diagnostics var = result_oid' statement
to
> get the oid of the new record, then do a select on the table to get the
> sequence column value for the new record using this oid, to obtain the new
> sequence value.

Um, what's wrong with "select currval('sequence_name')" ?

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco



pgsql-novice by date:

Previous
From: Derek Clarkson
Date:
Subject: OID stuff
Next
From: "Juliet May"
Date:
Subject: Re: New and investigating