ganuri@gmail.com writes:
> given a table:
> create table test ( testarray int[]);
> this gives an error
> insert into test (testarray[1], testarray[2]) values (1,2),(3,4)
> ERROR: multiple assignments to same column "testarray"
Yeah, that ought to work, but fixing it is nontrivial --- see
https://www.postgresql.org/message-id/9578.1469645245%40sss.pgh.pa.us
In the meantime, it works to do it with INSERT/SELECT, eg
insert into test (testarray[1], testarray[2])
select 1,2 union all select 3,4;
or even
insert into test (testarray[1], testarray[2])
select * from (values (1,2),(3,4)) v;
regards, tom lane
