> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
>
> Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> >> Peter Eisentraut <peter_e@gmx.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.
>
> > 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).
And ORDER BY ?
> Which is not great, but I think we've
> finally seen the light: a locale-sorted index is just plain not useful
> for LIKE.
I'm not familiar with non_ASCII locale.
Is 'ss' always guaranteed to be LIKE 's%' for example ?
regards,
Hiroshi Inoue