Re: returning multiple result sets from a stored procedure

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: returning multiple result sets from a stored procedure
Дата
Msg-id 1283469376-sup-7696@alvh.no-ip.org
обсуждение исходный текст
Ответ на returning multiple result sets from a stored procedure  (John Adams <john_adams_mail@yahoo.com>)
Ответы Re: returning multiple result sets from a stored procedure  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
Excerpts from John Adams's message of jue sep 02 18:25:45 -0400 2010:
> I noticed in postgres you cannot return multiple result sets from a stored 
> procedure (surprisingly as it looks like a very good dbms). 

If you're really intent about doing this, you can emulate it by
returning a set of refcursors.

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

В списке pgsql-hackers по дате отправления:

Предыдущее
От: John Adams
Дата:
Сообщение: returning multiple result sets from a stored procedure
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!)