| From: | Holger Klawitter <holger(at)klawitter(dot)de> |
|---|---|
| To: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: Counting affected rows |
| Date: | 2000-07-10 09:36:19 |
| Message-ID: | 39699913.E60BE09C@klawitter.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-sql |
> How can I count the number of rows affected by UPDATE or DELETE?
This depends on the interface you are using.
* The psql SQL monitor always reports the number of affected rows
(it's the 2nd number)
* In DBI "do" returns the number of affected rows.
* In JDBC "executeUpdate" does the same. (By the way, is there a way
to get the number of rows from a executeQuery without counting them?).
Regards,
Mit freundlichem Gruß,
Holger Klawitter
--
Holger Klawitter +49 (0)251 484 0637
holger(at)klawitter(dot)de http://www.klawitter.de/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gabriel López Millán | 2000-07-10 10:33:51 | JDBC and LOB |
| Previous Message | Gabriel López Millán | 2000-07-10 09:28:20 | binary data ... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zeugswetter Andreas SB | 2000-07-10 10:02:58 | AW: Re: [SQL] Re: [GENERAL] lztext and compression rati os... |
| Previous Message | Przem Kowalczyk | 2000-07-10 07:51:28 | Counting affected rows |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ice Planet | 2000-07-10 11:40:44 | Type conversion |
| Previous Message | Oliver Elphick | 2000-07-10 09:16:30 | Re: CREATE TABLE with foreign key and primary key |