Re: PL/pgSQL: FOT Loops vs Cursors - Mailing list pgsql-novice

From Mike G.
Subject Re: PL/pgSQL: FOT Loops vs Cursors
Date
Msg-id 20050211043921.GA16189@thegodshalls.thegodshalls
Whole thread Raw
In response to PL/pgSQL: FOT Loops vs Cursors  ("Van Ingen, Lane" <lvaningen@ESNCC.com>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: "Sal Dkj"
Date:
Subject: Converting interval to numeric?
Next
From: Bruno Wolff III
Date:
Subject: Re: Converting interval to numeric?