Re: How to tell if that UPDATE worked? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: How to tell if that UPDATE worked?
Date
Msg-id 200101120509.AAA28023@candle.pha.pa.us
Whole thread Raw
In response to Re: How to tell if that UPDATE worked?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> 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.

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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: Dan Moschuk
Date:
Subject: Re: exit status 26
Next
From: Tom Lane
Date:
Subject: Re: exit status 26