Re: PL/PGSQL CURSOR looping/iteration - PG 8.3 - Mailing list pgsql-general

From Tom Lane
Subject Re: PL/PGSQL CURSOR looping/iteration - PG 8.3
Date
Msg-id 9705.1223481309@sss.pgh.pa.us
Whole thread Raw
In response to PL/PGSQL CURSOR looping/iteration - PG 8.3  (<cyw@dls.net>)
List pgsql-general
<cyw@dls.net> writes:
> I see some proposal for implementing FOR loop for cursor in PG 8.4, but I could not found documentaion on how to loop
oriterate thru a cursor in PG 8.3 or earler versions? 

    LOOP
        FETCH ...;
        EXIT WHEN NOT FOUND;
        ...
    END LOOP;

            regards, tom lane

pgsql-general by date:

Previous
From:
Date:
Subject: PL/PGSQL CURSOR looping/iteration - PG 8.3
Next
From: Wojciech Strzałka
Date:
Subject: Re: Stats collector eats my CPU