Re: Counting elements of an array

Christopher Sawtell wrote:

> On Thu, 01 Mar 2001 21:53, you wrote:
> > Good morning all,
> >
> > I would like to know how I can get the number of elements of an array.
>
> create function array_element_count(_int4) returns integer as '
> declare
> a alias for $1;
> i integer;
> begin
> i := 1;
> while a[i] loop
> i := i+1;
> end loop;
> return i-1;
> end;' language 'plpgsql' with(isstrict,iscachable);
>

Thanks a lot
Regards, Renaud THONNART