Re: [BUGS] Possible regression in 'UPDATE ... SET () =' with just one single column/row value since v10

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [BUGS] Possible regression in 'UPDATE ... SET () =' with just one single column/row value since v10
Дата
Msg-id CAKFQuwYLcxGUtBJEEuUUo=NZ-KDNyuB_DacaPV=0csXjoBLbXA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [BUGS] Possible regression in 'UPDATE ... SET () = ' with just one single column/row value since v10  (YasonTR <yasontr@protonmail.com>)
Ответы Re: [BUGS] Possible regression in 'UPDATE ... SET () = ' with just one single column/row value since v10
Список pgsql-bugs
Дерево обсуждения
On Tue, Oct 24, 2017 at 7:55 AM, YasonTR <yasontr@protonmail.com> wrote:
Hi Tom,

I get your reference to the spec, but why is it working without ROW() when multiple columns are involved? For example: "UPDATE my_table SET (a, b) = (x, y)" works on v10 (afaik).


​https://www.postgresql.org/docs/10/static/sql-expressions.html#sql-syntax-row-constructors

"​The key word ROW is optional when there is more than one expression in the list."

David J.

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

Предыдущее
От: YasonTR
Дата:
Сообщение: Re: [BUGS] Possible regression in 'UPDATE ... SET () = ' with just one single column/row value since v10
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] Possible regression in 'UPDATE ... SET () = ' with just one single column/row value since v10