Re: returning multiple result sets from a stored procedure

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
protocolas 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
sequencesbefore the backend finishes processing the query string. ReadyForQuery is issued when the entire string has
beenprocessed 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