Thread: cursors Vs for loops in pl/pgsql

cursors Vs for loops in pl/pgsql

From
"Tim McAuley"
Date:
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