Message-ID: <005b01c522bc$6a31ece0$1f6df345@WATSON>
From: "Sean Davis" <sdavis2@mail.nih.gov>
To: "bandeng" <postgredb@gmail.com>, <pgsql-sql@postgresql.org>
References: <3817e22905030608544a2aac9a@mail.gmail.com>
	<20050306191055.GA8834@winnie.fuhr.org>
	<3817e22905030618091584b1d1@mail.gmail.com>
Subject: Re: count array in postgresql
Date: Sun, 6 Mar 2005 21:21:47 -0500
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit

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
>