Re: [SQL] count array in postgresql

2005-03-06 Thread Michael Fuhr
On Mon, Mar 07, 2005 at 09:09:57AM +0700, bandeng wrote: > I still cannot find count function in that reference. See array_upper() and array_lower(). -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 5: Have you checked our

Re: [SQL] count array in postgresql

2005-03-06 Thread Sean Davis
How about array_dims? It looks like you will still have to do a string split, but Sean - Original Message - From: "bandeng" <[EMAIL PROTECTED]> To: Sent: Sunday, March 06, 2005 9:09 PM Subject: Re: [SQL] count array in postgresql my Postgresql version is 7.4 I s

Re: [SQL] count array in postgresql

2005-03-06 Thread bandeng
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 :=

Re: [SQL] count array in postgresql

2005-03-06 Thread Michael Fuhr
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 s