Re: SET syntax in INSERT

On 01/14/2016 03:00 PM, Marko Tiikkaja wrote:
> 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.
>
>
>


Right. Why not just forbid anything other than a plain column name on 
the LHS for INSERT, at least as a first cut.

cheers

andrew