X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B8AD2D6F0D for ; Wed, 24 Aug 2005 06:22:21 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 58252-06 for ; Wed, 24 Aug 2005 09:22:18 +0000 (GMT) Received: from mail.webhotel.net (mail.webhotel.net [217.145.49.10]) by svr1.postgresql.org (Postfix) with SMTP id 09A30D6E07 for ; Wed, 24 Aug 2005 06:22:14 -0300 (ADT) Received: (qmail 32565 invoked from network); 24 Aug 2005 09:22:12 -0000 Received: from unknown (HELO ?192.168.42.125?) (62.66.186.164) by mail.webhotel.net with SMTP; 24 Aug 2005 09:22:12 -0000 Message-ID: <430C3C40.4070906@netgroup.dk> Date: Wed, 24 Aug 2005 11:22:08 +0200 From: Bo Lorentsen User-Agent: Debian Thunderbird 1.0.2 (X11/20050817) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: Number of rows in a cursor ? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.235 required=5 tests=[AWL=-0.235, TO_ADDRESS_EQ_REAL=0.47] X-Spam-Level: X-Archive-Number: 200508/209 X-Sequence-Number: 22437 Hi ... Is it possible to get the total number of rows found in a cursor, or must I make a count(*) and then a select ? /BL