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 AEB7DD6F0F
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 24 Aug 2005 06:55:27 -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 28424-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 24 Aug 2005 09:55:25 +0000 (GMT)
Received: from navicon.dk
	(cpe.atm1-0-1091060.0x50a3778a.arcnxe1.customer.tele.dk
	[80.163.119.138])
	by svr1.postgresql.org (Postfix) with ESMTP id A08D6D6D87
	for <pgsql-sql@postgresql.org>; Wed, 24 Aug 2005 06:55:23 -0300 (ADT)
Received: from [127.0.0.1] ([10.0.1.123]:3098)
	by raptus.navicon.dk with [XMail 1.21 ESMTP Server]
	id <S4CDB4> for <pgsql-sql@postgresql.org> from <tbs@navicon.dk>;
	Wed, 24 Aug 2005 11:55:18 +0200
Message-ID: <430C43F5.2030506@navicon.dk>
Date: Wed, 24 Aug 2005 11:55:01 +0200
From: Thomas Borg Salling <tbs@navicon.dk>
User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Bo Lorentsen <bl@netgroup.dk>
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: Re: Number of rows in a cursor ?
References: <430C3C40.4070906@netgroup.dk>
In-Reply-To: <430C3C40.4070906@netgroup.dk>
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.65 required=5 tests=[AWL=0.600,
	FORGED_RCVD_HELO=0.05]
X-Spam-Level: 
X-Archive-Number: 200508/210
X-Sequence-Number: 22438

Bo Lorentsen wrote:

> Is it possible to get the total number of rows found in a cursor, or 
> must I make a count(*) and then a select ?

Perhaps:
GET DIAGNOSTICS rc = ROW_COUNT;

(see http://archives.postgresql.org/pgsql-novice/2003-06/msg00143.php 
and 
http://www.postgresql.org/docs/8.0/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS)

/Thomas.