Re: Counting elements of an array

From: Renaud Tthonnart <thonnart(at)amwdb(dot)u-strasbg(dot)fr>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Counting elements of an array
Date: 2001-03-12 16:14:25
Message-ID: 3AACF5E1.3891363B@amwdb.u-strasbg.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Sorry!!
It works very well!

Renaud THONNART

> Renaud Tthonnart <thonnart(at)amwdb(dot)u-strasbg(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mark G. Gilmore 2001-03-12 16:17:54 Re: Create trigger problem :
Previous Message Renaud Tthonnart 2001-03-12 15:26:21 Re: Counting elements of an array