Postgres Pro
Downloads
Home   >   mailing lists

[BUGS] Possible regression in 'UPDATE ... SET () = ' with just one single column/row value since v10 - Mailing list pgsql-bugs

From YasonTR
Subject [BUGS] Possible regression in 'UPDATE ... SET () = ' with just one single column/row value since v10
Date
Msg-id DzifLcHs-9wlp5kq6MPKTxu6zI8s5LhAEaVsrq_NRTuQTkw_EWrogrLgDhQ7i5W-cvaIPig0gH59FzBk7Lwr8FUvV7H0fLOYI8heueaoG1Y=@protonmail.com
Whole thread Raw
Responses Re: [BUGS] Possible regression in 'UPDATE ... SET () = ' with just one single column/row value since v10
List pgsql-bugs
Tree view
Hi,

The following (odd) construction worked in pgv9.x: "UPDATE my_table SET (my_col) = (some value)". This no longer works in v10. It gives the error "source for a multiple-column UPDATE item must be a sub-SELECT or ROW() expression". It looks like it only breaks when the column list just holds one single column.

Possibly related to:


Let me know if you need more information.

Thank you. Warm regards,

YasonTR

pgsql-bugs by date:

Previous
From: tschimail1@gmail.com
Date:
Subject: [BUGS] BUG #14868: Postgres as Windows Service doesn't shutdown properly
Next
From: Pavel Suderevsky
Date:
Subject: Re: [BUGS] BUG #14863: wrong reltuples statistics after vacuum without analyze