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 97F4BD729E
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 24 Aug 2005 09:50:09 -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 63548-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 24 Aug 2005 12:50:06 +0000 (GMT)
Received: from mail.webhotel.net (mail.webhotel.net [217.145.49.10])
	by svr1.postgresql.org (Postfix) with SMTP id 6A1C4D7257
	for <pgsql-sql@postgresql.org>; Wed, 24 Aug 2005 09:50:04 -0300 (ADT)
Received: (qmail 82329 invoked from network); 24 Aug 2005 12:50:07 -0000
Received: from unknown (HELO ?192.168.42.125?) (62.66.186.164)
	by mail.webhotel.net with SMTP; 24 Aug 2005 12:50:07 -0000
Message-ID: <430C6CFF.9070304@netgroup.dk>
Date: Wed, 24 Aug 2005 14:50:07 +0200
From: Bo Lorentsen <bl@netgroup.dk>
User-Agent: Debian Thunderbird 1.0.2 (X11/20050817)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Russell Simpkins <russellsimpkins@hotmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Number of rows in a cursor ?
References: 
 <B74B7433CDDD2C4AA41D94832E32E19D92EE9A@EMEXM1112.dir.svc.accenture.com>
	<430C4C70.2010005@netgroup.dk>
	<BAY103-DAV72BF461390EA073012267B5A80@phx.gbl>
In-Reply-To: <BAY103-DAV72BF461390EA073012267B5A80@phx.gbl>
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/222
X-Sequence-Number: 22450

Russell Simpkins wrote:

> If you need a count, why not just execute one of the methods to get a 
> count. i.e.e select count(id) ...

The reason why i don't  just make a count and then a selection of data 
is performance.

/BL