Sorry!!
It works very well!
Renaud THONNART
> Renaud Tthonnart <[EMAIL PROTECTED]> writes:
> > I would like to know how I can get the number of elements of an array.
>
> There is a function that returns an array's dimensions as a text string:
>
> regression=# select array_dims( '{1,2,3}'::int[] );
> array_dims
> ------------
> [1:3]
> (1 row)
>
> regression=# select array_dims( '{{1,2,3},{4,5,6}}'::int[] );
> array_dims
> ------------
> [1:2][1:3]
> (1 row)
>
> regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
