Re: [GENERAL] UPDATE syntax change (column-list UPDATE syntax failswith single column) - Mailing list pgsql-general

From Justin Pryzby
Subject Re: [GENERAL] UPDATE syntax change (column-list UPDATE syntax failswith single column)
Date
Msg-id 20171030163404.GF21735@telsasoft.com
Whole thread Raw
In response to [GENERAL] UPDATE syntax change  (Adam Brusselback <adambrusselback@gmail.com>)
Responses Re: [GENERAL] UPDATE syntax change (column-list UPDATE syntax failswith single column)  (Adam Brusselback <adambrusselback@gmail.com>)
List pgsql-general
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.GA19616%40telsasoft.com#20170719174507.GA19616@telsasoft.com

Justin


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: [GENERAL] gin index trouble
Next
From: Stephen Frost
Date:
Subject: Re: [GENERAL] Backup strategy using 'wal_keep_segments'