Re: "between" is using index but "like" is not - Mailing list pgsql-novice

Josh Berkus wrote:

> Jesper,
>
>
>>Why doesn't it use an index on the "like" operator when it doesn't contain
>>a wildcard in the beginning of the pattern?
>
>
> How many rows are there in the table?   What happens if you force an index
> scan on the 2nd query?  Is this ASCII text or UNICODE text?
>
> Normally LIKE 'xxx%' does use an index if it's useful, so there is something
> else going on here.

Shall not him define an index with the right operator class in order to be used
with the like operator ?



Regards
Gaetano Mendola