Re: Progress report on locale safe LIKE indexing

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Progress report on locale safe LIKE indexing
Дата
Msg-id Pine.LNX.4.30.0108181245160.677-100000@peter.localdomain
обсуждение исходный текст
Ответ на Re: Progress report on locale safe LIKE indexing  (Hiroshi Inoue <Inoue@tpf.co.jp>)
Ответы RE: Progress report on locale safe LIKE indexing  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Список pgsql-hackers
Hiroshi Inoue writes:

> > An operator class text_binary_ops that does memcmp()-based comparison of
> > text data.  The operators are named $<$ etc. for lack of a better idea.
> > That lack is further illustrated by the idea to name them "binary-<" etc.,
> > which wouldn't get through the parser, but it doesn't need to.
> >
> > The system will use such an index for the queries in question if the
> > locale is not "like-safe", in the terminology of the code (I'll end up
> > renaming that a little).
>
> This depends on the assumption that '=' is equivalent in
> any locale. Is it guaranteed ?
> For example, ( 'a' = 'A' ) isn't allowed in any locale ?

The whole point here is not to rely on '='.  Instead we use a different
opclass which does "locale-safe" comparisons, as said above.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



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

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: encoding names
Следующее
От: "Hiroshi Inoue"
Дата:
Сообщение: RE: Progress report on locale safe LIKE indexing