Re: Bidimensional Array

On 12/26/2011 12:23 PM, Leandro Guimarães wrote:
> Hello Kris,
>    thanks for your answer. The dataType is varchar.
>
>    I did a workaround to solve the problem, but i'm sure it's not a good
> approach.
>
>    I'm using the a1.toString() method and using .split by comma to break
> the value and return the String[]
>

Your problem is that you don't really have a two dimensional array.  You
have a one dimensional array whose contents look similar to an array,
but are actually just a string of text.

jurka=# select array_ndims('{"{319.1,811.2,915.5}"}'::varchar[]);
  array_ndims
-------------
            1


Those interior quotes are not correct.

jurka=# select array_ndims('{{319.1,811.2,915.5}}'::varchar[]);
  array_ndims
-------------
            2

jurka=# select ('{{319.1,811.2,915.5}}'::varchar[])[1][1];
  varchar
---------
  319.1

Kris Jurka