Re: returning multiple result sets from a stored procedure - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: returning multiple result sets from a stored procedure
Date
Msg-id AANLkTimDURGDwuykoQQQ2tfcJsFq6_x7qBKhjpTUoMQa@mail.gmail.com
Whole thread Raw
In response to Re: returning multiple result sets from a stored procedure  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: returning multiple result sets from a stored procedure
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #5305: Postgres service stops when closing Windows session