Re: CREATE TYPE with array - Mailing list pgsql-novice

Wolfgang Drotschmann <drotschm@fgan.de> writes:
> create table xs ( a char(5), l int4array[]);
> CREATE TABLE
> insert into xs values('abcde', '{1,2,3,4}');
> ERROR:  array_in: Need to specify dimension

int4array is already an array; I don't think you want to make an array
of arrays.  It might work if you wrote the value as something like

    '{''{1,2,3}'',''{4,5,6}''}'

(not sure that I have the quoting quite right here) but that sure seems
like the hard way compared to using a multidimensional array.

In short, declare l as int4array not int4array[].

            regards, tom lane