Re: [GENERAL] multiple results from a function

2014-03-03 Thread James Harper
> > James Harper wrote on 03.03.2014 21:10: > > I'm working on an application to accept TDS (Microsoft SQL Server) > > connections and proxy them to postgres. MSSQL does things a little > > differently, for instance in addition to a functions it has stored > > procedures that can contain multiple

Re: [GENERAL] multiple results from a function

2014-03-03 Thread Thomas Kellerer
James Harper wrote on 03.03.2014 21:10: I'm working on an application to accept TDS (Microsoft SQL Server) connections and proxy them to postgres. MSSQL does things a little differently, for instance in addition to a functions it has stored procedures that can contain multiple select statement th

Re: [GENERAL] multiple results from a function

2014-03-03 Thread James Harper
> > I'm building against 9.3 at the moment, and my code is external to the > > postgres process and using libpq connections, but I noticed that 9.4 allows > > dynamic backend worker processes which would allow my code to run server > > side and spawn a process for each TDS connection. > > Hm, inte

Re: [GENERAL] multiple results from a function

2014-03-03 Thread Merlin Moncure
On Mon, Mar 3, 2014 at 2:10 PM, James Harper wrote: >> >> On Thu, Feb 27, 2014 at 6:23 PM, James Harper >> wrote: >> > I see that I can use PQgetResult to get results from an async query, and >> > this >> allows for multiple results, presumably when the query is like "SELECT 123, >> 456; SELECT

Re: [GENERAL] multiple results from a function

2014-03-03 Thread James Harper
> > On Thu, Feb 27, 2014 at 6:23 PM, James Harper > wrote: > > I see that I can use PQgetResult to get results from an async query, and > > this > allows for multiple results, presumably when the query is like "SELECT 123, > 456; SELECT 'ABC', 'DEF';". Is there a way for a C function, using SPI,

Re: [GENERAL] multiple results from a function

2014-03-03 Thread Merlin Moncure
On Thu, Feb 27, 2014 at 6:23 PM, James Harper wrote: > I see that I can use PQgetResult to get results from an async query, and this > allows for multiple results, presumably when the query is like "SELECT 123, > 456; SELECT 'ABC', 'DEF';". Is there a way for a C function, using SPI, to > send

[GENERAL] multiple results from a function

2014-02-27 Thread James Harper
I see that I can use PQgetResult to get results from an async query, and this allows for multiple results, presumably when the query is like "SELECT 123, 456; SELECT 'ABC', 'DEF';". Is there a way for a C function, using SPI, to send result sets without waiting for completion and returning a pot