Re: patch: shared session variables

2012/8/31 Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr>:
> Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> writes:
>> a motivation for this patch was discussion about parametrised DO
>> statement - and simple possibility of access to host variables (psql)
>> variables from server - PL scripts.
>
> Pavel, you didn't say what you think about the WITH FUNCTION proposal?

I don't like it - this proposal is too "lispish" - it is not SQL

>
> And you didn't say how do you want to turn a utility statement into
> something that is able to return a result set.

if we support "real" procedures ala sybase procedures (MySQL, MSSQL..)
- then we can return result with same mechanism - there are no
significant difference between DO and CALL statements - you don't know
what will be result type before you call it.

Regards

Pavel Stehule

>
> Regards,
> --
> Dimitri Fontaine
> http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support