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

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.

Why? (And yes, I ran analyze each time.)

Thanks,
Martin.

Am 07.01.2004 um 13:08 schrieb Martin Hampl:

> 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.
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org
>