Re: multidimensional arrays - Mailing list pgsql-general

From Tom Lane
Subject Re: multidimensional arrays
Date
Msg-id 11733.1107406618@sss.pgh.pa.us
Whole thread Raw
In response to multidimensional arrays  (mstory@uchicago.edu)
List pgsql-general
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

pgsql-general by date:

Previous
From: Alex Turner
Date:
Subject: Re: Problems with filter on timestamp
Next
From: "Anil"
Date:
Subject: Re: Scanning the PGSQL DB