Re: PL/pgSQL: FOT Loops vs Cursors

Поиск
Список
Период
Сортировка
От Mike G.
Тема Re: PL/pgSQL: FOT Loops vs Cursors
Дата
Msg-id 20050211043921.GA16189@thegodshalls.thegodshalls
обсуждение исходный текст
Ответ на PL/pgSQL: FOT Loops vs Cursors  ("Van Ingen, Lane" <lvaningen@ESNCC.com>)
Список 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 по дате отправления:

Предыдущее
От: "Sal Dkj"
Дата:
Сообщение: Converting interval to numeric?
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Converting interval to numeric?