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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

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 using a FOR loop, since FOR automatically uses a cursor anyway. They both avoid memory problems. Have I missed something or are there other reasons?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)