Thread: Rows UPDATEd?

Rows UPDATEd?

From
"David Olbersen"
Date:
I'm looking for a way to see how many rows were UPDATEd. I Googled a bit and found that if I were using pl/pgsql I
coulduse 'GET DIAGNOSTICS'. But I'm not using pl/pgsql. Is there some other way I could find out how many rows were
affectedby the last statement in my transaction? 

For what it's worth, a Perl script is doing this using the Pg module. I didn't see anything in the Pg man page
describingthis. It does cover INSERT and DELETE by using "$cmdStatus = $result->cmdStatus", but not UPDATE. 

Any suggestions?

--------------------------
David Olbersen
iGuard Engineer
11415 West Bernardo Court
San Diego, CA 92127
1-858-676-2277 x2152