Re: is it possible to recover more than one recordset or cursor from a function?

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: is it possible to recover more than one recordset or cursor from a function?
Дата
Msg-id AFCCBB403D7E7A4581E48F20AF3E5DB2036897B0@EXADV1.host.magwien.gv.at
обсуждение исходный текст
Ответ на is it possible to recover more than one recordset or cursor from a function?  ("guillermo arias" <guillermoariast@linuxwaves.com>)
Ответы Re: is it possible to recover more than one recordset or cursor from a function?  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Список pgsql-general
Дерево обсуждения 
guillermo arias wrote:
>
> is it possible to recover more than one recordset or cursor
> from a function?
> I use to do it in ms sql server, but it is a mistery for me
> in postgre.

CREATE FUNCTION returns2cursors(OUT c1 refcursor, OUT c2 refcursor)
LANGUAGE plpgsql AS ....

Yours,
Laurenz Albe

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

Предыдущее
От: MC Moisei
Дата:
Сообщение: Re: Ubuntu, Postgresql-8.2 and remote access thru pg_hba.conf
Следующее
От: "Pavel Stehule"
Дата:
Сообщение: Re: is it possible to recover more than one recordset or cursor from a function?