Re: How to tell if that UPDATE worked?

Jan Wieck <janwieck@Yahoo.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