Ruben Rubio Rey <ruben(at)rentalia(dot)com> writes:
> 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?
What's the array datatype? Integer or float would probably go a lot
faster than NUMERIC, if that's what you're using now.
regards, tom lane