Re: Enhanced psql in core?

2011/7/10 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>:
> 2011/7/10 Jaime Casanova <jaime(at)2ndquadrant(dot)com>:
>> On Sat, Jul 9, 2011 at 5:29 AM, hubert depesz lubaczewski
>> <depesz(at)depesz(dot)com> wrote:
>>> hi,
>>> would it be possible to incorporate
>>> http://www.postgres.cz/index.php/Enhanced-psql in core PostgreSQL/psql?
>>>
>>> This patch adds lots of nice functionalities, which we could definitely
>>> use.
>>>
>>
>> big part of this seems to be (based on the examples on the page,
>> haven't read the patch) scripting functionality but now that we have
>> DO, is really a need for that?
>> i'm not really sure if we can do what the same as your example using
>> DO but i'm really dubious about the usefullness of that example.
>>
>
> DO has same limits like functions - you cannot to switch database, you
> cannot to store data to psql's session variables, you cannot do
> "include file"
>

note - a output from DO statement is limited to RAISE statement - you
can't send back a SELECT's result

Regards

Pavel

> Regards
>
> Pavel
>
>
>
>> --
>> Jaime Casanova         www.2ndQuadrant.com
>> Professional PostgreSQL: Soporte 24x7 y capacitación
>>
>> --
>> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-hackers
>>
>