Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group