Re: will the planner ever use an index when the condition is <> ?

On Sun, Dec 18, 2011 at 16:52, Roxanne Reid-Bennett <rox@tara-lu.com> wrote:
> Is there an index type that can check "not equal"?
> This specific column has a limited number of possible values - it is
> essentially an enumerated list.

Instead of writing WHERE foo<>3 you could rewrite it as WHERE foo IN
(1,2,4,...) or WHERE foo < 3 OR foo > 3. Both of these are indexable
queries, but obviously the planner may choose not to use index scan if
it's not worth it.

Regards,
Marti