Why is UPDATE with column-list syntax not implemented

Поиск
Список
Период
Сортировка
От AK
Тема Why is UPDATE with column-list syntax not implemented
Дата
Msg-id 1385058513821-5779600.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: Why is UPDATE with column-list syntax not implemented  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
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.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Dilip kumar
Дата:
Сообщение: Re: Logging WAL when updating hintbit
Следующее
От: Rajeev rastogi
Дата:
Сообщение: Re: COPY table FROM STDIN doesn't show count tag