Thread: PL/pgSQL: FOT Loops vs Cursors

PL/pgSQL: FOT Loops vs Cursors

From
"Van Ingen, Lane"
Date:
After reading the manual (8.0: pages 582, 584). I am not certain what real advantage there is to using a cursor over
usinga FOR loop, since FOR automatically uses a cursor anyway. They both avoid memory problems. Have I missed something
orare there other reasons?
 

Re: PL/pgSQL: FOT Loops vs Cursors

From
"Mike G."
Date:
See page 587.  Cursors can be referenced by other functions and be created semi-dynamically.

On Thu, Feb 10, 2005 at 01:53:42PM -0500, Van Ingen, Lane wrote:
> After reading the manual (8.0: pages 582, 584). I am not certain what real advantage there is to using a cursor over
usinga FOR loop, since FOR automatically uses a cursor anyway. They both avoid memory problems. Have I missed something
orare there other reasons? 
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings