> 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@klawitter.de http://www.klawitter.de/