Comparing strings with non-ASCII characters

From: Artur Rataj <arataj(at)iitis(dot)gliwice(dot)pl>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Comparing strings with non-ASCII characters
Date: 2002-11-13 12:47:46
Message-ID: Pine.LNX.4.33.0211131251340.11103-100000@linux.iitis.gliwice.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Is it possible in Postgres to use non-ASCII characters and have enabled
index optimizations for the ~ operator? Would it work correctly with
locale set to C for expressions of the form ~ '^string.*'? Or is there a
way to substitue expressions like this with two comparisons? I have tried
to do it like that >= 'string' and <= 'string_' where _ would be a
character sorted after any other used in the searched table, but I did
not found such a character in the locale pl_PL. Anyway, why the index
optimizations are disabled for the ~ operator and not for the < or >
operators in the locale? Is not there a similar problem with all of the
three operators in a non-ASCII locale? Could not the lack of index
optimizations be fixed in Postgres for locales like pl_PL with a simple
reordering of characters for a collator, at least to get the < and >
operators working right with index optimizations in such locales?

Best regards,
Artur Rataj

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2002-11-13 13:20:43 Re: Upgrade to dual processor machine?
Previous Message Adam Witney 2002-11-13 12:02:34 Re: Can not connect to the database ..oops