From: Sean Davis <sdavis2@mail.nih.gov>
To: bandeng <postgredb@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: count array in postgresql
Date: Sun, 6 Mar 2005 21:21:47 -0500
Message-ID: <005b01c522bc$6a31ece0$1f6df345@WATSON> (raw)
References: <3817e22905030608544a2aac9a@mail.gmail.com>
<20050306191055.GA8834@winnie.fuhr.org>
<3817e22905030618091584b1d1@mail.gmail.com>
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
>
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: sdavis2@mail.nih.gov, postgredb@gmail.com
Subject: Re: count array in postgresql
In-Reply-To: <005b01c522bc$6a31ece0$1f6df345@WATSON>
* 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