View Single Post

   
  #2 (permalink)  
Old 04-17-2008, 09:30 PM
Mike G.
 
Posts: n/a
Default Re: PL/pgSQL: FOT Loops vs Cursors

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)

Reply With Quote