Re: partial index on varchar-coloumn in 7.4.1

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Martin Hampl <Martin(dot)Hampl(at)gmx(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: partial index on varchar-coloumn in 7.4.1
Date: 2004-01-07 16:09:04
Message-ID: 20040107080616.U18778@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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).

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Martin Hampl 2004-01-07 16:27:02 Re: partial index on varchar-coloumn in 7.4.1
Previous Message Tom Lane 2004-01-07 15:29:39 Re: partial index on varchar-coloumn in 7.4.1