Re: Counting affected rows - Mailing list pgsql-general

> 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/