Re: Possible solution for LIKE optimization

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Possible solution for LIKE optimization
Дата
Msg-id 13626.997062771@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Possible solution for LIKE optimization  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Wait, why isn't that the solution in the first place.  Let's build the
> index with an opclass that uses plain strcmp comparison.

By George, I think you've got it!  All we need is comparison ops and
an opclass that use strcmp, even when USE_LOCALE is defined.  Then we
document "here's how you make a LIKE-compatible index in non-ASCII
locales", and away we go.
        regards, tom lane


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

Предыдущее
От: Digital Wokan
Дата:
Сообщение: Sorry about that unsubscribe
Следующее
От: Tom Lane
Дата:
Сообщение: Re: partial index