Thread: Why is UPDATE with column-list syntax not implemented

Why is UPDATE with column-list syntax not implemented

From
AK
Date:
9.3 documentation says:

According to the standard, the column-list syntax should allow a list of
columns to be assigned from a single row-valued expression, such as a
sub-select:

UPDATE accounts SET (contact_last_name, contact_first_name) =   (SELECT last_name, first_name FROM salesmen    WHERE
salesmen.id= accounts.sales_id); 
This is not currently implemented — the source must be a list of independent
expressions.

Why is this not implemented? Is it considered inconvenient to use, or
difficult to implement. or not important enough, or some other reason?



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Why-is-UPDATE-with-column-list-syntax-not-implemented-tp5779600.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.



Re: Why is UPDATE with column-list syntax not implemented

From
Tom Lane
Date:
AK <alkuzo@gmail.com> writes:
> 9.3 documentation says:
> According to the standard, the column-list syntax should allow a list of
> columns to be assigned from a single row-valued expression, such as a
> sub-select:

> UPDATE accounts SET (contact_last_name, contact_first_name) =
>     (SELECT last_name, first_name FROM salesmen
>      WHERE salesmen.id = accounts.sales_id);
> This is not currently implemented — the source must be a list of independent
> expressions.

> Why is this not implemented? Is it considered inconvenient to use, or
> difficult to implement. or not important enough, or some other reason?

It's difficult to implement.  You'd need to do some significant
restructuring of the way UPDATE is handled.  Probably someone will
attempt it at some point.
        regards, tom lane



Re: Why is UPDATE with column-list syntax not implemented

From
AK
Date:
Thank you, Tom!



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Why-is-UPDATE-with-column-list-syntax-not-implemented-tp5779600p5779899.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.