Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6E5B02E2DA5 for ; Thu, 15 Nov 2007 11:36:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 82449-03-4 for ; Thu, 15 Nov 2007 11:35:55 -0400 (AST) Received: from diana.fh-erfurt.de (diana.fh-erfurt.de [193.174.232.67]) by postgresql.org (Postfix) with SMTP id ACE0D2E2DAE for ; Thu, 15 Nov 2007 11:36:12 -0400 (AST) Received: from clio.fh-erfurt.de(193.174.232.65) by diana.fh-erfurt.de via smtp id 3b29_85efc912_9392_11dc_9d7a_001143366b7e; Thu, 15 Nov 2007 16:50:42 +0100 (CET) Received: from [195.37.147.134] by clio.fh-erfurt.de (Sun Java(tm) System Messaging Server 6.3-3.01 (built Jul 12 2007; 32bit)) with ESMTPA id <0JRK007JX0LRA6F0@clio.fh-erfurt.de> for pgsql-interfaces@postgresql.org; Thu, 15 Nov 2007 16:34:39 +0100 (CET) Date: Thu, 15 Nov 2007 16:36:10 +0100 From: Bert Horvath Subject: Re: C-Interface Amound of Tupels in Result after COPYout In-reply-to: <2564.1195140420@sss.pgh.pa.us> To: pgsql-interfaces@postgresql.org Reply-to: bert.horvath@fh-erfurt.de Message-id: <473C676A.2070805@fh-erfurt.de> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-15; format=flowed Content-transfer-encoding: QUOTED-PRINTABLE References: <473C3851.6060300@fh-erfurt.de> <2564.1195140420@sss.pgh.pa.us> User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.278 tagged_above=0 required=5 tests=AWL=0.277, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200711/8 X-Sequence-Number: 6652 i have allready tryed out this it allways returns 0... Tom Lane schrieb: > Bert Horvath writes: >> do i have any chance to get the amount of tupels in the result set= after=20 >> executing a query with a copy command? Its not a problem to cou= nt the=20 >> columns with PQnFields(*conn,*result) but there is no documentatio= n f=FCr=20 >> PQnTupels(*conn,*result) and it does not work. >=20 > PQcmdTuples. PQnTuples is for the number of rows actually returned= to > the client by a SELECT. >=20 > =09=09=09regards, tom lane >=20 > ---------------------------(end of broadcast)----------------------= ----- > TIP 2: Don't 'kill -9' the postmaster >=20 --=20 Bert Horvath MSc Angewandte Informatik FB Geb=E4udetechnik und Informatik wissenschaftlicher Mitarbeiter, Projekt MoSDeP Fachhochschule Erfurt - University of Applied Sciences Altonaer Str. 25, D-99085 Erfurt (Haus 10, Raum 10.01.09) Tel: +49 361 / 6700 - 393 Fax: +49 361 / 6700 - 8960 E-Mail: bert.horvath@fh-erfurt.de