From: Holger Klawitter <holger@klawitter.de>
To: pgsql-general@postgreSQL.org
Subject: Re: Counting affected rows
Date: Mon, 10 Jul 2000 11:36:19 +0200
Message-ID: <39699913.E60BE09C@klawitter.de> (raw)
References: <NEBBINEAELLIDFDPANNDEENKCGAA.przem@fire>
> 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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: holger@klawitter.de, pgsql-general@postgreSQL.org
Subject: Re: Counting affected rows
In-Reply-To: <39699913.E60BE09C@klawitter.de>
References: <NEBBINEAELLIDFDPANNDEENKCGAA.przem@fire> <39699913.E60BE09C@klawitter.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox