Re: count array in postgresql

my Postgresql version is 7.4

I still cannot find count function in that reference. but I try to use
like this just checking the array value is null or not, it's work but
dunno it is the good way or not.

for example,
vararray := {ab,cd,ef,gh}

i := 1;
while vararray[i] is not null loop
i := i + 1;
end loop;

raise info i;

On Sun, 6 Mar 2005 12:10:55 -0700, Michael Fuhr <mike(at)fuhr(dot)org> wrote:
> On Sun, Mar 06, 2005 at 11:54:15PM +0700, bandeng wrote:
>
> > I need some help, I have created function with argument in array.
> > I already try to find array function in manual but failed.
>
> Maybe you're looking for "Array Functions and Operators" in the
> "Functions and Operators" chapter. You don't say what version of
> PostgreSQL you're using; here's a link to the 8.0 documentation:
>
> http://www.postgresql.org/docs/8.0/interactive/functions-array.html
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
>

--
Gutten Aben Sugeng Sonten, Jangane Kurang Santen
bandeng....................