Re: How to tell if that UPDATE worked?

> 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.

The good news is that this is a new 7.1 feature, and I haven't checked
all the HISTORY items for documentation updates yet.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026