Daniel J. Summers wrote:
> Andrzej Zawadzki wrote:
>> Daniel J. Summers wrote:
>>
>>> Tony Liao wrote:
>>>
>>>> I try to explain analyze,but it doesn't work ,it use seq scan.
>>>>
>>> Generally speaking, LIKE doesn't use indexes.
>>>
>> ?! That's not true at all!!
>>
[...]
> PostgreSQL (the great subject of this mailing list) doesn't do it with
> a standard index (5) - you've got to use a special operator class.
Please try... with "C" locales. Works out of the box.
--
Andrzej Zawadzki