BUG #14265: inserting multiple rows via array notation gives error

From: ganuri(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14265: inserting multiple rows via array notation gives error
Date: 2016-07-27 00:57:25
Message-ID: 20160727005725.7438.26021@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14265
Logged by: Nuri Boardman
Email address: ganuri(at)gmail(dot)com
PostgreSQL version: 9.4.5
Operating system: Windows 7 - 64
Description:

given a table:
create table test ( testarray int[]);

this completes as i would expect
insert into test (testarray[1], testarray[2]) values (1,2)

this gives an error
insert into test (testarray[1], testarray[2]) values (1,2),(3,4)
ERROR: multiple assignments to same column "testarray"

I'm not sure if this is supported or not, as i didn't see any documentation
about it.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2016-07-27 01:37:37 Re: BUG #7808: unnest doesn't handle nulls in array of composite typescorrectly
Previous Message Bruce Momjian 2016-07-27 00:23:41 Re: BUG #14226: pg_upgrade for 8.4 to 9.4 failed