Re: like and optimization

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: like and optimization
Дата
Msg-id 5704.980036577@sss.pgh.pa.us
обсуждение исходный текст
Ответ на like and optimization  (Juriy Goloveshkin <juriy@avias.com>)
Список pgsql-hackers
Juriy Goloveshkin <juriy@avias.com> writes:
> Hello, I didn't know pgsql-sources close,
> so I wrote this code just as example of idea.
> Can somebody review and make patch for pgsql?

AFAICT this only deals with the issue of single-byte characters that
sort in an order different from their numeric order.  The existing
make_greater_string() code already deals with that case.  Where it
falls down is cases where sorting is context-dependent (multi-pass
sort rules, digraphs, things like that).  But I don't see anything
here that would make such cases work.

If you're trying to tell us that the 7.0.* code works correctly for
KOI8-R locale, we'd be glad to re-enable LIKE optimization for that
locale ...
        regards, tom lane


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

Предыдущее
От: Ian Lance Taylor
Дата:
Сообщение: Re: AW: AW: AW: Re: tinterval - operator problems on AIX
Следующее
От: Tom Lane
Дата:
Сообщение: Re: C++ interface build on FreeBSD 4.2 broken?