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?