Array performance

ruben@rentalia.com

From: Ruben Rubio Rey <ruben@rentalia.com>
To: pgsql-performance@postgresql.org
Date: 2006-03-24T12:41:50Z
Lists: pgsql-performance
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
AND array[20]<>0
AND array[21]<>0
 ...
AND array[50]<>0
AND array[51])<>0

Any ideas to make this query faster?