Tom Lane wrote: > > 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. > > 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
