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

ok,thank your respone.I'll make it back to pg v9 syntax.

---Original---
From: "Andrew Gierth"<andrew(at)tao11(dot)riddles(dot)org(dot)uk>
Date: Tue, Jun 12, 2018 18:28 PM
To: "Tom Lane"<tgl(at)sss(dot)pgh(dot)pa(dot)us>;
Cc: "pgsql-bugs"<pgsql-bugs(at)lists(dot)postgresql(dot)org>;"110876189"<110876189(at)qq(dot)com>;
Subject: Re: BUG #15237: I got "ERROR: source for a multiple-column UPDATE item must be a sub-SELECT or ROW() expression"

>>>>> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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)