Re: Return unknown resultset from a function

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Return unknown resultset from a function
Дата
Msg-id 12092.1330963706@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Return unknown resultset from a function  (Merlin Moncure <mmoncure@gmail.com>)
Ответы Re: Return unknown resultset from a function  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
Merlin Moncure <mmoncure@gmail.com> writes:
> The only exception to this rule is cursors.  Reading from cursors via
> FETCH allows you to pull data from a refcursor that was set up in a
> previous function call and works pretty well, but comes with the giant
> downside that the results can be directed only to the client.

Hmm, couldn't you do a FETCH into a record variable in plpgsql?  Not
that you'd not have problems manipulating the record variable, since
plpgsql is pretty strongly typed itself.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Memory usage and configuration settings
Следующее
От: Mike C
Дата:
Сообщение: Re: Memory usage and configuration settings