Re: returning multiple result sets from a stored procedure

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: returning multiple result sets from a stored procedure
Дата
Msg-id AANLkTimDURGDwuykoQQQ2tfcJsFq6_x7qBKhjpTUoMQa@mail.gmail.com
обсуждение исходный текст
Ответ на Re: returning multiple result sets from a stored procedure  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
2010/9/9 Alvaro Herrera <alvherre@commandprompt.com>:
> Excerpts from Pavel Stehule's message of jue sep 09 14:29:57 -0400 2010:
>
>> * how can be implemented OUT variables - the original implementation
>> is simple - it's just pointer, but it's not directly possible inside
>> postgres, because we use a MemoryContexts?
>
> Why is this a problem?  Just return a bunch of tuplestores, no?

and what context do you use? And you will pack and unpack tuple when
some field will be changed every time?

this is an possibility to solve our performance problems with arrays
or strings.

Regards

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


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: returning multiple result sets from a stored procedure
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] BUG #5305: Postgres service stops when closing Windows session