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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Hampl | 2004-01-07 15:23:50 | Re: partial index on varchar-coloumn in 7.4.1 |
Previous Message | Martin Hampl | 2004-01-07 12:08:59 | partial index on varchar-coloumn in 7.4.1 |