[postgis-users] Very large WHERE clause?

[DrYSG]

My users are presented with a list of checkbox for 4 different attributes
(e.g. type of image, country, etc.)

For type of image they can choose JPG, PNG, JP2000, etc. or turn off the
check box.

My naive implementation would have a WHERE clause with over 40 different
tests (type='JPG' OR type='PNG' OR country='USA' ...)

There has to be an more efficient way to do this (and gives better hints to
the PLANNER).

Suggestions? 

--
View this message in context: http://postgis.17.n6.nabble.com/Very-large-WHERE-clause-tp4952906.html
Sent from the PostGIS - User mailing list archive at Nabble.com.