Re: cursors and for loops? - Mailing list pgsql-sql

From Dennis
Subject Re: cursors and for loops?
Date
Msg-id courier.40799269.00004AC6@wolverine.lercnetworks.com
Whole thread Raw
In response to Re: cursors and for loops?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: cursors and for loops?  (Richard Huxton <dev@archonet.com>)
Re: cursors and for loops?  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Bret Hughes
Date:
Subject: Re: trigger/for key help
Next
From: Tom Lane
Date:
Subject: Re: trigger/for key help