From:
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To:
Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc:
Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>,
Josh Berkus <josh(at)agliodbs(dot)com>,
John Adams <john_adams_mail(at)yahoo(dot)com>,
PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: returning multiple result sets from a stored procedure
Date:
2010-09-05 18:05:18
Message-ID:
4C83DBDE.2080603@enterprisedb.com (view raw or flat )
Thread:
2010-09-02 22:25:45 from John Adams <john_adams_mail(at)yahoo(dot)com>
2010-09-02 23:17:00 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-09-03 19:27:19 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2010-09-03 20:07:03 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-09-03 20:18:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-05 18:26:03 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2010-09-07 12:27:23 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2010-09-03 20:40:56 from John Adams <john_adams_mail(at)yahoo(dot)com>
2010-09-03 21:20:32 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-09-03 21:24:46 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-09-06 07:07:54 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-06 18:07:18 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-09-06 21:40:38 from David Fetter <david(at)fetter(dot)org>
2010-09-06 21:58:55 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-04 13:39:16 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2010-09-04 14:10:14 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-04 14:16:15 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2010-09-04 15:00:55 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-05 18:05:18 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-09-05 18:18:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-05 23:56:42 from Andrew Chernow <ac(at)esilo(dot)com>
2010-09-08 23:44:07 from John Adams <john_adams_mail(at)yahoo(dot)com>
2010-09-09 07:12:47 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 15:58:25 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2010-09-09 17:13:11 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 17:51:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-09 17:55:52 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 18:29:57 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 18:37:39 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-09-09 18:43:44 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 20:08:31 from Darren Duncan <darren(at)darrenduncan(dot)net>
2010-09-09 20:16:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-09 20:22:42 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-10 15:27:40 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-09-09 20:25:58 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-09-09 20:59:28 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-09 21:09:42 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-09-09 21:51:57 from Darren Duncan <darren(at)darrenduncan(dot)net>
2010-09-09 21:12:24 from Darren Duncan <darren(at)darrenduncan(dot)net>
2010-09-09 21:52:46 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 20:35:07 from Darren Duncan <darren(at)darrenduncan(dot)net>
2010-09-09 20:44:18 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-10 04:49:16 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2010-09-09 20:17:43 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 20:22:31 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-09 20:29:45 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 20:46:49 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-09-09 20:53:05 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 20:59:02 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 21:07:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-09 21:13:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-09-09 21:26:11 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-09-09 21:47:28 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-09 21:40:40 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2010-09-10 04:47:27 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2010-09-10 05:02:14 from Darren Duncan <darren(at)darrenduncan(dot)net>
Lists:
pgsql-hackers
On 04/09/10 17:16, Merlin Moncure wrote:
> Curious: is mulitset handling as you see it supported by the current
> v3 protocol?
The manual says:
> The response to a SELECT query (or other queries that return row sets, such as EXPLAIN or SHOW) normally consists of RowDescription, zero or more DataRow messages, and then CommandComplete. COPY to or from the frontend invokes special protocol as described in Section 46.2.5. All other query types normally produce only a CommandComplete message.
>
> Since a query string could contain several queries (separated by semicolons), there might be several such response sequences before the backend finishes processing the query string. ReadyForQuery is issued when the entire string has been processed and the backend is ready to accept a new query string.
If a multiple return sets from a procedure are returned just like
multiple return sets from multiple queries, that's already covered by
the protocol.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2010-09-05 18:18:22Subject : Re: returning multiple result sets from a stored procedure Previous :From : Simon RiggsDate : 2010-09-05 16:58:29Subject : Re: Interruptible sleeps (was Re: CommitFest 2009-07:
Yay, Kevin! Thanks, reviewers!)
