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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
|
Try Searching:
servers, voip, java, networking, microsoft ...
|
|
|
|