DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references;
	b=QF2p4ieJ3CDNkfGnxgmlg+WNDtxnew+556aBGmpBYOV7kA03Fu6SP2mhG0T2lYlfTsqr9FdEhljLNWZ1v8g5Jn4Dq9AKzBnIWD1VaWge4ut/gatoC21Ohx758VAgYLIGQV6S+UkBKE24yqfyH3oxqcH5PlRIz8Sza67WGxBpOOQ=
Message-ID: <3817e22905030618091584b1d1@mail.gmail.com>
Date: Mon, 7 Mar 2005 09:09:57 +0700
From: bandeng <postgredb@gmail.com>
Reply-To: bandeng <postgredb@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: count array in postgresql
In-Reply-To: <20050306191055.GA8834@winnie.fuhr.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
References: <3817e22905030608544a2aac9a@mail.gmail.com>
	<20050306191055.GA8834@winnie.fuhr.org>

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....................