Re: proposal: PLpgSQL parallel assignemnt

2017-06-02 10:06 GMT+02:00 Craig Ringer <craig(at)2ndquadrant(dot)com>:

> On 2 June 2017 at 15:51, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
>
> > a, b := fx();
> >
> > Comments, notes, ideas?
>
> I'd be pretty happy to have
>
> (a, b) = (x, y);
> (a, b) = f(x);
>
> which is SQL-esque.
>

This is not too far to my proposal - and it is fully adequate alternative.

>
> But what, if anything, does Ada do?
>

What I know, no, Ada has not this statement - but the design of OUT
parameters in Ada absolutely different than PostgreSQL - so in this case we
cannot to use Ada language as our base :(

Regards

Pavel

>
> --
> Craig Ringer http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>