multiple results from a function - Mailing list pgsql-general

From James Harper
Subject multiple results from a function
Date
Msg-id 6035A0D088A63A46850C3988ED045A4B6F3BD70A@BITCOM1.int.sbss.com.au
Whole thread Raw
Responses Re: multiple results from a function  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
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?

Thanks

James


pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Doubts after evaluating Xlogdump
Next
From: Dev Kumkar
Date:
Subject: Re: Issue with default values and Rule