Received: from clubserv.rp-online.de (clubserv.rp-online.de [149.221.232.11]) by hub.org (8.9.3/8.9.3) with ESMTP id EAA64620 for ; Sun, 23 May 1999 04:01:39 -0400 (EDT) (envelope-from Michael.Meskes@gmx.net) Received: from pc63.rp-plus.de (as14-118.rp-plus.de [149.221.92.118]) by clubserv.rp-online.de (8.9.1a/8.9.1) with ESMTP id KAA18772 for ; Sun, 23 May 1999 10:01:04 +0200 (METDST) Received: (from meskes@localhost) by pc63.rp-plus.de (8.9.3/8.9.0/Debian/GNU) id KAA00294 for pgsql-interfaces@postgresql.org; Sun, 23 May 1999 10:00:15 +0200 Date: Sun, 23 May 1999 10:00:15 +0200 From: Michael Meskes To: pgsql-interfaces@postgresql.org Subject: Re: [INTERFACES] What to use to get number of tuples in a query Message-ID: <19990523100015.B250@gmx.net> Mail-Followup-To: pgsql-interfaces@postgresql.org References: <3745D54E.B3FCD745@presys.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.4i In-Reply-To: <3745D54E.B3FCD745@presys.com>; from Hitesh Patel on Fri, May 21, 1999 at 02:51:10PM -0700 On Fri, May 21, 1999 at 02:51:10PM -0700, Hitesh Patel wrote: > What should I use to get the number of tuples returned by a PQexec()? > PQntuples seems to be doing the job but i'm not sure if that is the > right thing to use. At least that's the command I use with ecpg. :-) However, if you're executing commands that do not return tuples you have to use PQcmdTuples(). Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! Email: Michael.Meskes@gmx.net | Use PostgreSQL!