Re: query planner: automatic rescribe of LIKE to BETWEEN ?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: query planner: automatic rescribe of LIKE to BETWEEN ?
Дата
Msg-id 11769.1156281153@sss.pgh.pa.us
обсуждение исходный текст
Ответ на query planner: automatic rescribe of LIKE to BETWEEN ?  (Ulrich Habel <espero7757@gmx.net>)
Список pgsql-performance
Ulrich Habel <espero7757@gmx.net> writes:
> Anythings speeks against this hack?

Only that it was done years ago.

As Alvaro mentions, if you are using a non-C locale then you need
non-default index opclasses to get it to work.  Non-C locales usually
have index sort orders that don't play nice with this conversion.

            regards, tom lane

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

Предыдущее
От: Charles Sprickman
Дата:
Сообщение: Benchmarks
Следующее
От: Jeff Davis
Дата:
Сообщение: PowerEdge 2950 questions