partial index on varchar-coloumn in 7.4.1

From: Martin Hampl <Martin(dot)Hampl(at)gmx(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: partial index on varchar-coloumn in 7.4.1
Date: 2004-01-07 12:08:59
Message-ID: 46AACD9C-410A-11D8-A66B-000393674318@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I am trying to use an partial index on a varchar-coloumn as described
in the documentation (section 11.7.)

The commands I ran were:

CREATE INDEX word_idx on token (word) where not (word = 'the');
ANALYZE;

The problem is: PostgreSQL doesn't seem to use this index at all. It
does use it if I create the index for the whole table.

Do partial indexes not work for varchar? Or do I have a syntax error in
my command?

Thanks,
Martin.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Martin Hampl 2004-01-07 14:56:07 Re: partial index on varchar-coloumn in 7.4.1
Previous Message Tom Lane 2004-01-06 18:00:31 Re: Integrity problem on 7.3.4