| From: | "Mike G(dot)" <mike(at)thegodshalls(dot)com> |
|---|---|
| To: | "Van Ingen, Lane" <lvaningen(at)ESNCC(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: PL/pgSQL: FOT Loops vs Cursors |
| Date: | 2005-02-11 04:39:21 |
| Message-ID: | 20050211043921.GA16189@thegodshalls.thegodshalls |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2005-02-11 04:58:25 | Re: Converting interval to numeric? |
| Previous Message | Sal Dkj | 2005-02-11 01:48:06 | Converting interval to numeric? |