>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
>> On PostgreSQL 11 Beta, I exec sql like "update
>> fvt_obj_operate_update_table_033 set (c_int) = (20) where c_int = 20;",
>> which only on column to set, got ""ERROR: source for a multiple-column
>> UPDATE item must be a sub-SELECT or ROW() expression"".
Tom> It's telling you what to do: use a ROW() expression, ie
Tom> update fvt_obj_operate_update_table_033 set (c_int) = row(20)
Tom> where c_int = 20;
Yeah, but (a) this used to work, and has worked since at least as far
back as 9.0, and (b) the spec requires it to work.
--
Andrew (irc:RhodiumToad)