This is probably the only way to do it. Still, it seems to me an overkill if
basically you need to run a function at each multidimensional array to get
access to each i-array element. Thanks for your answer.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Postgresql-mu
On Sat, Feb 1, 2014 at 6:45 PM, alexandros_e wrote:
> I do:
>
> SELECT '{{1,2},{3,4}}'::INTEGER[][]
>
> But I get:
>
> {{1,2},{3,4}} INTEGER[]. Somehow the PostgreSQL server does not understand
> that is a multidimensional array. So, later if I want to get {1,2} or {3,4},
> the field[1] or field[2
I do:
SELECT '{{1,2},{3,4}}'::INTEGER[][]
But I get:
{{1,2},{3,4}} INTEGER[]. Somehow the PostgreSQL server does not understand
that is a multidimensional array. So, later if I want to get {1,2} or {3,4},
the field[1] or field[2]. Evem when I try:
field [1:1] I get {{1,2}} and not plain one dim
