Ymir <ymir@wolfheart.ro> writes:
> I'm trying to use a bidimensional array and I'm having the following
> problem:
> students=# UPDATE years SET y_grade[1] = '{2,3,4,5,6,7}';
> ERROR: pg_atoi: error in "{2,3,4,5,6,7}": can't parse "{2,3,4,5,6,7}"
Not the right subscripts for an array slice. Try it this way:
regression=# create table years(y_grade int[]);
CREATE
regression=# insert into years values('{{1,2,3,4,5,6},{11,22,33,44,55,66}}');
INSERT 164022 1
regression=# select * from years;
y_grade
-------------------------------------
{{1,2,3,4,5,6},{11,22,33,44,55,66}}
(1 row)
regression=# update years set y_grade[1][1:6] = '{2,3,4,5,6,7}';
UPDATE 1
regression=# select * from years;
y_grade
-------------------------------------
{{2,3,4,5,6,7},{11,22,33,44,55,66}}
(1 row)
> I've declared y_grade as a bidimensional array (y_grade smallint[][]), but
> still, I get this when I describe the table:
The declaration of the table just says that the column is an array of
int; the number of dimensions is not really constrained, any more than
the array size is.
regards, tom lane
