refcurosr vs. setof

Поиск
Список
Период
Сортировка
От Rüdiger Herrmann
Тема refcurosr vs. setof
Дата
Msg-id d3ugoo$2oq8$1@news.hub.org
обсуждение исходный текст
Ответы Re: refcurosr vs. setof
Список pgsql-performance
Hello,

I need to write several PL/pgSQL functions all returning a "result set" wich
can be obtained by a single SELECT statement.
For now the functions are called by a Java application.
Both REFCURSOR and SETOF serve my purpose, but I was wondering if there is a
perfonance difference between the two. The result set can become quite
large.

I hope not to ask this question the 1001 time, though I couldn't find
anything on the net.. Any hints are welcome.

Regards
R�diger



В списке pgsql-performance по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: plperl vs plpgsql
Следующее
От: Christopher Browne
Дата:
Сообщение: Re: plperl vs plpgsql