Re: 7.3 no longer using indexes for LIKE queries

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: 7.3 no longer using indexes for LIKE queries
Дата
Msg-id Pine.LNX.4.44.0212092037110.25355-100000@localhost.localdomain
обсуждение исходный текст
Ответ на Re: 7.3 no longer using indexes for LIKE queries  (Hiroshi Inoue <Inoue@tpf.co.jp>)
Список pgsql-general
Hiroshi Inoue writes:

> For example, there could be case-insensitive collations.

You could do that, but normally you would take account the case
differences in the third pass.

Another interesting problem is how you would expect to handle
multicharacter collating elements that cross wildcard boundaries (like
'oc%' when 'ch' is a collating element).  That would give weird results.

--
Peter Eisentraut   peter_e@gmx.net


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

Предыдущее
От: Medi Montaseri
Дата:
Сообщение: Re: UPDATE syntax problem
Следующее
От: Joe Conway
Дата:
Сообщение: Re: table functions