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:
- https://www.postgresql.org/message-id/8542.1479742008%40sss.pgh.pa.us
- https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=906bfcad7
Let me know if you need more information.
Thank you. Warm regards,
YasonTR