Re: Solution found! was Re: Finding the number of rows affected by UPDATE or INSERT?

Note that a zero rowcount does not necessarily mean an error; it may just
mean that the WHERE clause in your UPDATE was not satisfied.  Which may be
equivalent to an error in your particular application: just not as a general
case.

----- Original Message -----
From: "Dr. Evil" <drevil@sidereal.kz>
To: <pgsql-general@postgresql.org>
Sent: Thursday, August 30, 2001 3:05 AM
Subject: [GENERAL] Solution found! was Re: Finding the number of rows
affected by UPDATE or INSERT?


>
> I found out how to do it:
>
> In pl/pgsql:
>
> INT nr;
>
> UPDATE ....
> GET DIAGNOSTICS SELECT PROCESSED INTO nr;
>
> will put the number of rows into nr.  It's a very useful feature to
> have this in PG7.1.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>