logo       
Google Custom Search
    AddThis Social Bookmark Button

Re: OID stuff: msg#00321

Subject: Re: OID stuff
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 ...
<Prev in Thread] Current Thread [Next in Thread>