X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 885EED1C4ED for ; Sun, 11 Apr 2004 18:03:34 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 27067-05 for ; Sun, 11 Apr 2004 18:03:38 -0300 (ADT) Received: from wolverine.lercnetworks.com (sabertooth.lercnetworks.com [140.99.13.90]) by svr1.postgresql.org (Postfix) with ESMTP id 6157FD1BAA5 for ; Sun, 11 Apr 2004 18:03:26 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) (uid 510) by wolverine.lercnetworks.com with local; Sun, 11 Apr 2004 14:46:01 -0400 References: <15008.1081699255@sss.pgh.pa.us> In-Reply-To: <15008.1081699255@sss.pgh.pa.us> From: "Dennis" To: "postgres SQL" Subject: Re: cursors and for loops? Date: Sun, 11 Apr 2004 14:46:01 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="utf-8" Content-Transfer-Encoding: 7bit Message-ID: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/109 X-Sequence-Number: 17484 Tom Lane writes: > Something like > > LOOP > FETCH ...; > EXIT WHEN NOT found; > ... > END LOOP; Thank you! I tried finding documentation on "found" in this context and didn't come up with anything. Can you point me to where it is documented? Also, I am not getting the results I think I should be getting. Is there any kind of debug setting, or if not that, a way to output text (i.e. printf) from plpgsql? Thanks, Dennis pg-user@calico-consulting.com