Does index based on text with 'en_US.utf8' collation support like query?

Поиск
Список
Период
Сортировка
От Haifeng Liu
Тема Does index based on text with 'en_US.utf8' collation support like query?
Дата
Msg-id BLU0-SMTP2953C508D5F6127617CC45AB93A0@phx.gbl
обсуждение исходный текст
Ответы Re: Does index based on text with 'en_US.utf8' collation support like query?  (Alexey Klyukin <alexk@commandprompt.com>)
Список pgsql-admin
Hi,

I found that queries like "select * from tbl where col1 like 'abc%'" will use index only when the col1(and the index)
use'C' collation. If I use 'default' which is 'en_US.utf8' in my database, the equation condition will use the index
butlike query will not. 

I also tried to specify the collation explicitly: like ('abc%' collate 'en_US.utf8'), not work too.

Is that only 'C' collation support 'like' query or I missed something in my sql? Or do I need to install something
additionalto support index on other collation? 

Thanks in advance.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Kong Man
Дата:
Сообщение: Re: log_min_messages=debug5, despite an explicit setting to warning on postgresql.conf
Следующее
От: Alexey Klyukin
Дата:
Сообщение: Re: Does index based on text with 'en_US.utf8' collation support like query?