PL/pgSQL: FOT Loops vs Cursors

From: "Van Ingen, Lane" <lvaningen(at)ESNCC(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: PL/pgSQL: FOT Loops vs Cursors
Date: 2005-02-10 18:53:42
Message-ID: A3FF4275060B76459B5C08A64AE330C86A3E@twmail.esncc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Van Ingen, Lane 2005-02-10 19:50:13 Using PL/pgSQL to Properly Define A Trigger
Previous Message Kjetil Haaland 2005-02-10 12:16:37 Re: function returning a row