Jim C. Nasby wrote:
On Fri, Mar 24, 2006 at 01:41:50PM +0100, Ruben Rubio Rey wrote:
Hi,
I have a select like
SELECT (array[20]+array[21]+ ... +array[50]+array[51]) as total
FROM table
WHERE
(array[20]+array[21]+ ... +array[50]+array[51])<5000
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?
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 ...
You might be able to greatly simplify that by use of ANY; you'd need to
ditch elements 1-19 though:
... WHERE NOT ANY(array) = 0
Yep this is much better.
See http://www.postgresql.org/docs/8.1/interactive/arrays.html
