Jan Wieck <janwieck(at)Yahoo(dot)com> writes:
> Do a
> GET DIAGNOSTICS SELECT PROCESSED INTO <int4_variable>;
> directly after an INSERT, UPDATE or DELETE statement and
> you'll know how many rows have been hit.
> Also you can get the OID of an inserted row with
> GET DIAGNOSTICS SELECT RESULT INTO <int4_variable>;
> Er - is this another added feature where we're still lacking
> documentation?
After a quick grep, I can state that the absolute sum total of the
documentation on this feature is:
HISTORY: New PL/pgSQL GET DIAGNOSTICS statement for SPI value access (Jan)
Better start writing.
regards, tom lane