Обсуждение: function returning resultset

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

function returning resultset

От
"William Anthony Lim"
Дата:
Hi,

I'm using PGSQL 7.4.1 and JDBC 75dev client.

I want to ask about PL/PGSQL function returning resultset.
I read in the docs, there are 'setof' and 'refcursor' method,
is there another method to returning resultset?
What advantages and disadvantages for each method?
Which is the best?

Plz explain to me. Thx.


W.A.


Need a new email address that people can remember
Check out the new EudoraMail at
http://www.eudoramail.com