From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Magnus Hagander <mha(at)sollentuna(dot)net> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Returning multiple result sets |
Date: | 2005-11-20 21:41:42 |
Message-ID: | 20051120214139.GH32031@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sun, Nov 20, 2005 at 10:01:24PM +0100, Magnus Hagander wrote:
> FWIW, MSSQL used to do only multiple sequential resultsets (from stored
> procs, or semicolon separated statements). With SQL 2005, they added
> interleaved ones - see
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90
> /html/MARSinSQL05.asp (loads of details both about how it was before and
> how it is in 2005)
I saw that page but my understanding of it is that you are now allowed
to submit a new query without reading all the results of the last one.
And that subsequent reading of results may be interleaved.
What it doesn't do is allow a single query to return multiple results
sets in an interleaved order.
What I'm trying to say is that the client can't read the results of a
function in any other order than it calls RETURN NEXT. OTOH, if the
server returns a cursor handle, the client can read the cursors in any
order it chooses.
Is this clear, or am I just confusing people (including possibly
myself)?
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-11-20 22:21:03 | Re: Plan chosen for PQexecParams |
Previous Message | Martijn van Oosterhout | 2005-11-20 21:30:48 | Re: Returning multiple result sets |