Re: Counting elements of an array - Mailing list pgsql-general

Renaud Tthonnart <thonnart@amwdb.u-strasbg.fr> 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