On Fri, Mar 24, 2006 at 02:01:29PM +0100, Ruben Rubio Rey wrote: > >http://www.varlena.com/GeneralBits/109.php might provide some useful > >insights. I also recall seeing something about sum operators for arrays, > >but I can't recall where. > > > > > I ll check it out, seems to be very useful > Is faster create a function to sum the array?
There's been talk of having one, but I don't think any such thing currently exists. > >>AND array[20]<>0 > >>AND array[21]<>0 > >>... > >>AND array[50]<>0 > >>AND array[51])<>0 > >> > >> > > > >Uhm... please don't tell me that you're using 0 in place of NULL... > > > > > mmm ... i have read in postgres documentation that null values on arrays > are not supported ... Damn, you're right. Another reason I tend to stay away from them... -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
