Re: BUG #15237: I got "ERROR: source for a multiple-column UPDATE item must be a sub-SELECT or ROW() expression" - Mailing list pgsql-bugs

>>>>> "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)