cursors Vs for loops in pl/pgsql

From: "Tim McAuley" <mcauleyt(at)tcd(dot)ie>
To: <pgsql-general(at)postgresql(dot)org>
Subject: cursors Vs for loops in pl/pgsql
Date: 2002-11-06 15:02:11
Message-ID: 000a01c285a5$8df42140$6802a8c0@MOTHY
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

We've recently upgraded our Postgresql from 7.1.3 to 7.2.1.

We use for loops in our stored procedures (due to the fact that cursors were
not present in pl/pgsql until now). I'm just wondering if this is the way to
continue or should we look at using cursors instead? Is there any
performance difference between the two (considering that for loops use
cursors internally anyway).

Thanks,

Tim

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-11-06 15:18:42 Re: Formatting psql output
Previous Message Tom Lane 2002-11-06 14:51:16 Re: CURRENT_TIME