Re: count array in postgresql - Mailing list pgsql-sql

From bandeng
Subject Re: count array in postgresql
Date
Msg-id 3817e22905030618091584b1d1@mail.gmail.com
Whole thread Raw
In response to Re: count array in postgresql  (Michael Fuhr <mike@fuhr.org>)
Responses Re: count array in postgresql
List pgsql-sql
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....................


pgsql-sql by date:

Previous
From: Stefan Weiss
Date:
Subject: Re: Links between rows in a table
Next
From: "Sean Davis"
Date:
Subject: Re: count array in postgresql