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(at)sidereal(dot)kz>
To: <pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org)
>
>