Received: from bbaer.muenster.de (root@bbaer.muenster.de [195.202.32.20]) by hub.org (8.10.1/8.10.1) with ESMTP id e6A9YxW36082 for ; Mon, 10 Jul 2000 05:34:59 -0400 (EDT) Received: from klawitter.de (holger@mueasb-wan126.citykom.de [195.202.39.126]) by bbaer.muenster.de (8.9.3/8.9.3) with ESMTP id LAA20936 for ; Mon, 10 Jul 2000 11:32:34 +0200 Message-ID: <39699913.E60BE09C@klawitter.de> Date: Mon, 10 Jul 2000 11:36:19 +0200 From: Holger Klawitter X-Mailer: Mozilla 4.7 [en] (X11; U; Linux 2.2.13 i686) X-Accept-Language: en, de-DE MIME-Version: 1.0 To: pgsql-general@postgreSQL.org Subject: Re: Counting affected rows References: Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200007/340 > 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/