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
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 |