Re: [GENERAL] Finding the number of rows affected by UPDATE or INSERT?

2001-08-30 Thread Joe Conway
I am writing a bunch of stuff in pl/pgsql, and some of these functions do UPDATEs or INSERTs on various tables. How could I find out, from within the pl/pgsql function, how many rows were affected? This way, if the update or insert fails for some reason, I can return a failed message from

[GENERAL] Finding the number of rows affected by UPDATE or INSERT?

2001-08-29 Thread Dr. Evil
I am writing a bunch of stuff in pl/pgsql, and some of these functions do UPDATEs or INSERTs on various tables. How could I find out, from within the pl/pgsql function, how many rows were affected? This way, if the update or insert fails for some reason, I can return a failed message from the