Re: Returning multiple result sets

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Returning multiple result sets
Дата
Msg-id BAY20-F2A7AE6DE50CE73B2C6FB8F9500@phx.gbl
обсуждение исходный текст
Ответ на Re: Returning multiple result sets  (Martijn van Oosterhout <kleptog@svana.org>)
Список 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 по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Returning multiple result sets
Следующее
От: pgsql@Safe-mail.net
Дата:
Сообщение: unsubscribe