On Mon, Oct 30, 2017 at 12:29:03PM -0400, Adam Brusselback wrote:
> I have some queries that were working in 9.6 which suddenly broke when
> moving to 10.
>
> Digging in, the error i'm getting is: ERROR: source for a
> multiple-column UPDATE item must be a sub-SELECT or ROW() expression
> So there was a change made, and you now cannot use the multi-column
> syntax if you're only updating a single column. Was this intentional?
I found the same while testing during beta:
https://www.postgresql.org/message-id/flat/20170719174507(dot)GA19616%40telsasoft(dot)com#20170719174507(dot)GA19616(at)telsasoft(dot)com
Justin