2012/8/31 Dimitri Fontaine <dimitri@2ndquadrant.fr>:
> Pavel Stehule <pavel.stehule@gmail.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