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
|
| Список | 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 по дате отправления: