| From: | "David Olbersen" <DOlbersen(at)stbernard(dot)com> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Rows UPDATEd? |
| Date: | 2003-05-29 17:00:32 |
| Message-ID: | E7E213858379814A9AE48CA6754F5ECB0D6E95@mail01.stbernard.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 could use 'GET DIAGNOSTICS'. But I'm not using pl/pgsql. Is there some other way I could find out how many rows were affected by 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 describing this. 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chad Thompson | 2003-05-29 17:19:57 | Index scan never executed? |
| Previous Message | Tiaan Wessels | 2003-05-29 16:35:34 | CREATE TABLES AS looses constraints |