Rows UPDATEd? - Mailing list pgsql-sql

From David Olbersen
Subject Rows UPDATEd?
Date
Msg-id E7E213858379814A9AE48CA6754F5ECB0D6E95@mail01.stbernard.com
Whole thread Raw
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Tiaan Wessels
Date:
Subject: CREATE TABLES AS looses constraints
Next
From: "Chad Thompson"
Date:
Subject: Index scan never executed?