pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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/




view thread (2+ messages)

Message-ID: <39699913.E60BE09C@klawitter.de>
Permalink:  ../39699913.E60BE09C@klawitter.de/
Also on:    postgresql.org/message-id/39699913.E60BE09C@klawitter.de

 · 

reply

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