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 <t...@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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
