Re: Returning multiple result sets - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Returning multiple result sets
Date
Msg-id BAY20-F2A7AE6DE50CE73B2C6FB8F9500@phx.gbl
Whole thread Raw
In response to Re: Returning multiple result sets  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
Hello

I thinking about solution based on setof cursors. This solustion has three 
big minus:
1. I can "unpack" cursors after finish of called procedure. If I get 
exception, or long query, I can show nothing.
2. Old clients don't understand and don't unpack cursor. Statement call is 
(+/-) == statement SELECT (more if call return only one table).
3. twice communication.

backend           client
==============
<--------------------- call
-----------------------> cursors
<---------------------- select cursor
------------------------> table

this isn't pretty solution. May be with minimal changes in code. I think, 
this need bigger changes and support next class of stored objects.

best regards
Pavel Stehule

_________________________________________________________________
Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci. 
http://messenger.msn.cz/



pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Returning multiple result sets
Next
From: pgsql@Safe-mail.net
Date:
Subject: unsubscribe