Re: partial index on varchar-coloumn in 7.4.1 - Mailing list pgsql-novice

On Wed, 7 Jan 2004, Martin Hampl wrote:

> Hi,
>
> I tried it again on an integer-coloumn. With 'create INDEX word_idx ON
> token (word) where word = 15;' it works, with 'create INDEX word_idx ON
> token (word) where not (word = 15);' it doesn't.

It works for me when the query is written with the partial index
condition.  It's not going to deduce that word=2 implies not(word=15).