Re: Progress report on locale safe LIKE indexing

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Progress report on locale safe LIKE indexing
Date: 2001-08-18 00:00:57
Message-ID: 3B7DB039.ACFE8D4B@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Lamar Owen 2001-08-18 00:12:48 PostgreSQL 7.1.3 RPM's available for download.
Previous Message Peter Eisentraut 2001-08-17 23:16:43 Re: encoding names