From: bandeng <postgredb@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: count array in postgresql
Date: Mon, 7 Mar 2005 09:09:57 +0700
Message-ID: <3817e22905030618091584b1d1@mail.gmail.com> (raw)
In-Reply-To: <20050306191055.GA8834@winnie.fuhr.org>
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....................
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: postgredb@gmail.com
Subject: Re: count array in postgresql
In-Reply-To: <3817e22905030618091584b1d1@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox