Re: Progress report on locale safe LIKE indexing

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: Progress report on locale safe LIKE indexing
Дата
Msg-id 3B7DB039.ACFE8D4B@tpf.co.jp
обсуждение исходный текст
Ответ на Progress report on locale safe LIKE indexing  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: Progress report on locale safe LIKE indexing  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Peter Eisentraut wrote:
> 
> I have so far implemented the following:
> 
> 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 ?

regards,
Hiroshi Inoue


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: crypt and null termination
Следующее
От: Lamar Owen
Дата:
Сообщение: PostgreSQL 7.1.3 RPM's available for download.