X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id BC8B49DCAEF;
	Sun, 11 Dec 2005 14:08:09 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 08878-05; Sun, 11 Dec 2005 14:08:09 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by postgresql.org (Postfix) with ESMTP id 6CC5B9DCAC0;
	Sun, 11 Dec 2005 14:08:07 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id jBBI86Aa017603;
	Sun, 11 Dec 2005 13:08:06 -0500 (EST)
To: "Foster, Stephen" <stephenlfoster@comcast.net>
cc: "'Michael Fuhr'" <mike@fuhr.org>, pgsql-general@postgresql.org,
	pgsql-sql@postgresql.org
Subject: Re: [SQL] Looking for information on PostgreSQL Stored Procedures 
In-reply-to: <000001c5fe7a$f95c2d00$2101a8c0@cfgod> 
References: <000001c5fe7a$f95c2d00$2101a8c0@cfgod>
Comments: In-reply-to "Foster, Stephen" <stephenlfoster@comcast.net>
	message dated "Sun, 11 Dec 2005 11:47:29 -0600"
Date: Sun, 11 Dec 2005 13:08:06 -0500
Message-ID: <17602.1134324486@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.003 required=5 tests=[AWL=0.003]
X-Spam-Score: 0.003
X-Spam-Level: 
X-Archive-Number: 200512/539
X-Sequence-Number: 88102

"Foster, Stephen" <stephenlfoster@comcast.net> writes:
> 	WHILE (--Lost on variable name for end of query;
> EmptyQueryResponse <> 0? --)

	WHILE FOUND
	LOOP
		...
	END LOOP

Although as Michael mentioned, this is all the hard way; any experienced
plpgsql programmer would forget the cursor entirely and just write a
FOR-loop.

			regards, tom lane