Vitaly Burovoy <vitaly.buro...@gmail.com> writes:
> On 1/14/16, Tom Lane <t...@sss.pgh.pa.us> wrote:
>> It's more than syntactic sugar; you are going to have to invent semantics,
>> as well, because it's less than clear what partial-field assignments
>> should do.
>> Assume a table with an int-array column, and consider
>> INSERT INTO foo SET arraycol = 7, arraycol = 11;
> Right part is a column name, not an expression. Isn't it?
UPDATE takes this just fine. The difference is that in UPDATE there's
no question what the starting value of the column is.
> You can't now do something like
> INSERT INTO foo (arraycol, arraycol) VALUES(7, 11);
Hm ... actually, you might want to try that before opining.
regards, tom lane
Sent via pgsql-hackers mailing list (firstname.lastname@example.org)
To make changes to your subscription: