Re: Large data sets and FOR LOOP's

On Wed, 2002-03-13 at 17:29, Jan Wieck wrote:

>     You  probably  want to upgrade to 7.2, because 7.2's PL/pgSQL
>     uses the newly available SPI cursors silently in FOR loops.
This sounds good, I like to upgrade anyway, also to take advantage of
the new vaccum.

>     Releases before 7.2 loaded the entire result set into  memory
>     (ahem, swap space) before entering the FOR loop.
This was what I guested, too :-)

Would a cursor have helped any ?

/BL