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 of system 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 row inserted by the most
recent SQL query. Note that RESULT_OID is only useful after an
INSERT query.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)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; ye fight and war, yet ye have not,
because ye ask not." James 4:2