From: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | 110876189(at)qq(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #15237: I got "ERROR: source for a multiple-column UPDATE item must be a sub-SELECT or ROW() expression" |
Date: | 2018-06-12 10:28:38 |
Message-ID: | 87r2lctidw.fsf@news-spur.riddles.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
>>>>> "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)
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Gierth | 2018-06-12 11:40:02 | Re: BUG #15237: I got "ERROR: source for a multiple-column UPDATE item must be a sub-SELECT or ROW() expression" |
Previous Message | Tom Lane | 2018-06-12 03:38:23 | Re: BUG #15237: I got "ERROR: source for a multiple-column UPDATE item must be a sub-SELECT or ROW() expression" |
From | Date | Subject | |
---|---|---|---|
Next Message | Geoff Winkless | 2018-06-12 10:48:14 | late binding of shared libs for C functions |
Previous Message | Julien Rouhaud | 2018-06-12 10:28:15 | Re: Proposal: Partitioning Advisor for PostgreSQL |