Hiroshi Inoue <[EMAIL PROTECTED]> writes:
>> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Wait, why isn't that the solution in the first place. Let's build the
> index with an opclass that uses plain strcmp comparison.
> Do we have to make 2 indexes for non_ASCII text field ?
You would if you want to use indexscans for both LIKE and "x < 'FOO'"
(ie, locale-aware comparisons). Which is not great, but I think we've
finally seen the light: a locale-sorted index is just plain not useful
for LIKE.
This discussion has restored my faith in index opclasses; finally we
have a real-world application of 'em that we can point to ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
