Home > mailing lists

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

From	Van Ingen, Lane
Subject	PL/pgSQL: FOT Loops vs Cursors
Date	February 10, 2005 21:53:55
Msg-id	A3FF4275060B76459B5C08A64AE330C86A3E@twmail.esncc.com Whole thread Raw
Responses	Re: PL/pgSQL: FOT Loops vs Cursors ("Mike G." <mike@thegodshalls.com>)
List	pgsql-novice

Tree view

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?

pgsql-novice by date:

From: Kjetil Haaland
Date: 10 February 2005, 15:17:02
Subject: Re: function returning a row

From: "Van Ingen, Lane"
Date: 10 February 2005, 22:50:37
Subject: Using PL/pgSQL to Properly Define A Trigger

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

Previous

Next