Re: patch: shared session variables - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: patch: shared session variables
Date
Msg-id CAFj8pRCTX63N5ERXgtg5-=1u93NYAJn2J2jiSLzvgVrMJ3N2Sg@mail.gmail.com
Whole thread Raw
In response to Re: patch: shared session variables  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Responses Re: patch: shared session variables
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: patch: shared session variables
Next
From: Miroslav Šimulčík
Date:
Subject: rows changed in current transaction