Обсуждение: cursors Vs for loops in pl/pgsql

Поиск
Список
Период
Сортировка

cursors Vs for loops in pl/pgsql

От
"Tim McAuley"
Дата:
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