Re: CREATE TYPE with array

Wolfgang Drotschmann <drotschm(at)fgan(dot)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