How about array_dims? It looks like you will still have to do a string
split, but....
Sean
----- Original Message -----
From: "bandeng" <postgredb@gmail.com>
To: <pgsql-sql@postgresql.org>
Sent: Sunday, March 06, 2005 9:09 PM
Subject: Re: [SQL] 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@fuhr.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....................
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
