Re: [HACKERS] PostgreSQL 10 parenthesized single-column updates canproduce errors - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: [HACKERS] PostgreSQL 10 parenthesized single-column updates canproduce errors
Date
Msg-id CAKFQuwZYvtyBXYey=smWfEUUEF6-1Y5CAm4vDbDY3MMFzK8_OQ@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] PostgreSQL 10 parenthesized single-column updates can produce errors  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] PostgreSQL 10 parenthesized single-column updates can produce errors  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Tue, Oct 31, 2017 at 3:43 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
According to the spec, the elements of a parenthesized
SET list should be assigned from the fields of a composite RHS.  If
there's just one element of the SET list, the RHS should be a single-field
composite value, and this syntax should result in extracting its field.
This patch doesn't do that; it preserves our previous broken behavior,
and thus just puts off the day of reckoning that inevitably will come.

​Definitely moderates my opinion in my concurrent emai​l...though postponement is not strictly bad given the seeming frequency of the existing problematic syntax in the wild already.

David J.

pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [HACKERS] PostgreSQL 10 parenthesized single-column updates canproduce errors
Next
From: Gilles Darold
Date:
Subject: Re: [HACKERS] proposal: schema variables