Tom Lane wrote:
>
> Peter Eisentraut <peter_e(at)gmx(dot)net> 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.
>
> By George, I think you've got it! All we need is comparison ops and
> an opclass that use strcmp, even when USE_LOCALE is defined. Then we
> document "here's how you make a LIKE-compatible index in non-ASCII
> locales", and away we go.
>
Do we have to make 2 indexes for non_ASCII text field ?
regards,
Hiroshi Inoue