Re: Progress report on locale safe LIKE indexing - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject Re: Progress report on locale safe LIKE indexing
Date
Msg-id 3B7DB039.ACFE8D4B@tpf.co.jp
Whole thread Raw
In response to Progress report on locale safe LIKE indexing  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Progress report on locale safe LIKE indexing
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: crypt and null termination
Next
From: Lamar Owen
Date:
Subject: PostgreSQL 7.1.3 RPM's available for download.