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 13B37D6FDA for ; Wed, 24 Aug 2005 07:31:14 -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 09654-01 for ; Wed, 24 Aug 2005 10:31:12 +0000 (GMT) Received: from mail.webhotel.net (mail.webhotel.net [217.145.49.10]) by svr1.postgresql.org (Postfix) with SMTP id 254C3D6FD0 for ; Wed, 24 Aug 2005 07:31:10 -0300 (ADT) Received: (qmail 47465 invoked from network); 24 Aug 2005 10:31:13 -0000 Received: from unknown (HELO ?192.168.42.125?) (62.66.186.164) by mail.webhotel.net with SMTP; 24 Aug 2005 10:31:13 -0000 Message-ID: <430C4C70.2010005@netgroup.dk> Date: Wed, 24 Aug 2005 12:31:12 +0200 From: Bo Lorentsen User-Agent: Debian Thunderbird 1.0.2 (X11/20050817) X-Accept-Language: en-us, en MIME-Version: 1.0 To: neil.saunders@accenture.com Cc: pgsql-sql@postgresql.org Subject: Re: Number of rows in a cursor ? References: In-Reply-To: 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.018 required=5 tests=[AWL=0.018] X-Spam-Level: X-Archive-Number: 200508/214 X-Sequence-Number: 22442 neil.saunders@accenture.com wrote: >You cannot count the number of rows in a cursor, unfortunately. I recently ran in to this problem. > > How sad, then I have to repeat the query, first for counting and last for data fetch :-( /BL