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

From Renaud Tthonnart
Subject Re: Counting elements of an array
Date
Msg-id 3AACF5E1.3891363B@amwdb.u-strasbg.fr
Whole thread Raw
In response to Counting elements of an array  (Renaud Tthonnart <thonnart@amwdb.u-strasbg.fr>)
List pgsql-general
Sorry!!
It works very well!

Renaud THONNART


> 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


pgsql-general by date:

Previous
From: Renaud Tthonnart
Date:
Subject: Re: Counting elements of an array
Next
From: "Mark G. Gilmore"
Date:
Subject: Re: Create trigger problem :