Re: getting oid of an INSERT automatically

On Wed, 2002-08-07 at 19:39, John Brothers wrote:
> Hello all,
> 
>    In pgplsql, is there any way to get the oid that is returned from an INSERT statement, without
> doing a 'follow-up' SELECT for the oid?

From the Programmers' Guide (PL/pgSQL section):
   23.5.5. Obtaining result status      GET DIAGNOSTICS variable = item [ , ... ] ;      This command allows retrieval
ofsystem status indicators. Each item   is a keyword identifying a state value to be assigned to the   specified
variable(which should be of the right data type to   receive it). The currently available status items are ROW_COUNT,
the  number of rows processed by the last SQL query sent down to the SQL   engine; and RESULT_OID, the Oid of the last
rowinserted by the most   recent SQL query. Note that RESULT_OID is only useful after an   INSERT query.    
 
-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                            
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
========================================   "Ye lust, and have not; ye kill, and desire to have,      and cannot obtain;
yefight and war, yet ye have not,      because ye ask not."            James 4:2