Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] proposal: PLpgSQL parallel assignemnt - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: [HACKERS] proposal: PLpgSQL parallel assignemnt
Date
Msg-id CAFj8pRCO0bywQnvv8ow__8mp+sYYXBD0mGAHPxn9v1V9YiU+iQ@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] proposal: PLpgSQL parallel assignemnt  (Craig Ringer <craig@2ndquadrant.com>)
Responses Re: [HACKERS] proposal: PLpgSQL parallel assignemnt  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Tree view


2017-06-02 10:06 GMT+02:00 Craig Ringer <craig@2ndquadrant.com>:
On 2 June 2017 at 15:51, Pavel Stehule <pavel.stehule@gmail.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

pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: [HACKERS] proposal: PLpgSQL parallel assignemnt
Next
From: "Mengxing Liu"
Date:
Subject: Re: [HACKERS] Re: [GSOC 17] Eliminate O(N^2) scaling fromrw-conflict tracking in serializable transactions