Re: [GENERAL] Counting elements of an array

[Renaud Tthonnart]

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