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

From Marko Tiikkaja
Subject Re: SET syntax in INSERT
Date
Msg-id 5697FE5B.6040209@joh.to
Whole thread Raw
In response to Re: SET syntax in INSERT  (Vitaly Burovoy <vitaly.burovoy@gmail.com>)
Responses Re: SET syntax in INSERT  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
On 2016-01-14 20:50, Vitaly Burovoy wrote:
> On 1/14/16, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Assume a table with an int-array column, and consider
>>
>> INSERT INTO foo SET arraycol[2] = 7, arraycol[4] = 11;
>
> Right part is a column name, not an expression. Isn't it?
> So "arraycol[2]" is not possible there.

I think the idea here was that it's allowed in UPDATE.  But I don't see 
the point of allowing that in an INSERT.


.m



pgsql-hackers by date:

Previous
From: Vitaly Burovoy
Date:
Subject: Re: SET syntax in INSERT
Next
From: Tom Lane
Date:
Subject: Re: SET syntax in INSERT