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 4F18AD7321 for ; Wed, 24 Aug 2005 11:29:01 -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 67867-03 for ; Wed, 24 Aug 2005 14:28:58 +0000 (GMT) Received: from mail.webhotel.net (mail.webhotel.net [217.145.49.10]) by svr1.postgresql.org (Postfix) with SMTP id F0277D7309 for ; Wed, 24 Aug 2005 11:28:55 -0300 (ADT) Received: (qmail 29337 invoked from network); 24 Aug 2005 14:29:00 -0000 Received: from unknown (HELO ?192.168.42.125?) (62.66.186.164) by mail.webhotel.net with SMTP; 24 Aug 2005 14:29:00 -0000 Message-ID: <430C842C.8000504@netgroup.dk> Date: Wed, 24 Aug 2005 16:29:00 +0200 From: Bo Lorentsen User-Agent: Debian Thunderbird 1.0.2 (X11/20050817) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Michael Fuhr Cc: Russell Simpkins , pgsql-sql@postgresql.org Subject: Re: Number of rows in a cursor ? References: <430C4C70.2010005@netgroup.dk> <430C6CFF.9070304@netgroup.dk> <20050824131921.GA39444@winnie.fuhr.org> In-Reply-To: <20050824131921.GA39444@winnie.fuhr.org> 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.017 required=5 tests=[AWL=0.017] X-Spam-Level: X-Archive-Number: 200508/228 X-Sequence-Number: 22456 Michael Fuhr wrote: >...which is the same reason a cursor doesn't know how many rows it will >fetch until you fetch them all (or MOVE to the end of the cursor, >which fetches the rows internally). > > So, Postgresql is not hidding something for me, it just, like me, don't know ? /BL