Re: [SQL] clarification about ARRAY constructor implementation

On Nov 11, 2011, at 8:38, the6campbells wrote: > consider the following > > create table TARRBINT ( RNUM integer not null , CARRBINT bigint array[5] ) ; > > Can someone clarify why Postgres does not like examples 2, 6 and 7 An array must have a base type; an empty array has nothing with whi

[SQL] clarification about ARRAY constructor implementation

consider the following create table TARRBINT ( RNUM integer not null , CARRBINT bigint array[5] ) ; Can someone clarify why Postgres does not like examples 2, 6 and 7 1.insert into TARRBINT(RNUM, CARRBINT) values ( 0, null); 2.insert into TARRBINT(RNUM, CARRBINT) values ( 0, ARRAY[]); 3.insert