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