Re: multiple results from a function

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: multiple results from a function
Дата
Msg-id CAHyXU0wHozNz7f57dT1hsP=Ag7gdWoPcnK=Jd-r7z_Df4eC9tg@mail.gmail.com
обсуждение исходный текст
Ответ на multiple results from a function  (James Harper <james.harper@bendigoit.com.au>)
Ответы Re: multiple results from a function  (James Harper <james.harper@bendigoit.com.au>)
Список pgsql-general
On Thu, Feb 27, 2014 at 6:23 PM, James Harper
<james.harper@bendigoit.com.au> wrote:
> I see that I can use PQgetResult to get results from an async query, and this allows for multiple results, presumably
whenthe query is like "SELECT 123, 456; SELECT 'ABC', 'DEF';". Is there a way for a C function, using SPI, to send
resultsets without waiting for completion and returning a potentially huge set of results right at the end of the
function?
>
> Failing that, is there a way for a C function to send to STDOUT in the same way that a COPY (...) TO STDOUT would?

Why does this have to be an SPI function?  Maybe a little more context
here would help.

merlin


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

Предыдущее
От: Jason Daly
Дата:
Сообщение: Re: 'tuple concurrently updated' error when granting permissions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Why is varchar_pattern_ops needed?