Thread: multidimensional arrays

multidimensional arrays

From
mstory@uchicago.edu
Date:

I'm writing a 2 dimensional array INTEGER[3][] that holds data that i need to
parse through to check for zeros.  The user will insert into this array one row
at a time, when i insert the first row into this array it works fine but when i
check  array_dims it gives me [1:3] not the [1:3][1:1] that i expected, also the
array lower and array upper for the second dimension i get a null value for
both, i checked the documentation and it says that multidimensional arrays act
strangly, but nothing i've read would give me the impression that something like
this should have happened.  Any help would be appreciated.

matt

Re: multidimensional arrays

From
Tom Lane
Date:
mstory@uchicago.edu writes:
> I'm writing a 2 dimensional array INTEGER[3][] that holds data that i
> need to parse through to check for zeros.  The user will insert into
> this array one row at a time, when i insert the first row into this
> array it works fine but when i check array_dims it gives me [1:3] not
> the [1:3][1:1] that i expected,

You assigned a one-dimensional value to the array, not a two-dimensional
value.

            regards, tom lane