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

Re: partial index on varchar-coloumn in 7.4.1

From: Martin Hampl <Martin(at)Hampl(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: partial index on varchar-coloumn in 7.4.1
Date: 2004-01-07 14:56:07
Message-ID: 9F54CB80-4121-11D8-A66B-000393674318@Hampl.de (view raw or flat)
Thread:
Lists: 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
>


In response to

pgsql-novice by date

Next:From: Martin HamplDate: 2004-01-07 15:23:50
Subject: Re: partial index on varchar-coloumn in 7.4.1
Previous:From: Martin HamplDate: 2004-01-07 12:08:59
Subject: partial index on varchar-coloumn in 7.4.1

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