From: | "Sim Zacks" <sim(at)nospam(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: FOR vs Cursors |
Date: | 2005-02-22 14:41:58 |
Message-ID: | cvfget$2js7$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
One advantage of a cursor over a for loop is that it makes your code more
portable.
It also allows you to bring existing code over without having to majorly
rewrite.
""Van Ingen, Lane"" <lvaningen(at)ESNCC(dot)com> wrote in message
news:A3FF4275060B76459B5C08A64AE330C86A37(at)twmail(dot)esncc(dot)com(dot)(dot)(dot)
> After reading the manual (8.0). 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 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2005-02-22 14:57:22 | Re: Is there a way to implicitly grant privileges to an implicitly created sequence? |
Previous Message | Bruno Wolff III | 2005-02-22 14:38:01 | Re: Off-topic: monograph for database postgraduate |