Tom Lane wrote:
Ruben Rubio Rey <ruben@xxxxxxxxxxxx> 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])<>0Any 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.
Already its integer[]
