Re: SET syntax in INSERT - Mailing list pgsql-hackers

From Tom Lane
Subject Re: SET syntax in INSERT
Date
Msg-id 15351.1452803156@sss.pgh.pa.us
Whole thread Raw
In response to Re: SET syntax in INSERT  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: SET syntax in INSERT
Re: SET syntax in INSERT
List pgsql-hackers
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Thu, Jan 14, 2016 at 1:07 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Vitaly Burovoy <vitaly.burovoy@gmail.com> writes:
>>> You can't now do something like
>>> INSERT INTO foo (arraycol[2], arraycol[4]) VALUES(7, 11);

>> Hm ... actually, you might want to try that before opining

> So what's the problem, then?  It seems like a decision has already been
> made.

Yeah, but is it a decision that we might later find to be at odds
with a future SQL standard?  The more places we embed that behavior,
the more risk we take.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Vitaly Burovoy
Date:
Subject: Re: SET syntax in INSERT
Next
From: "David G. Johnston"
Date:
Subject: Re: SET syntax in INSERT