> -----Original Message----- > From: Tom Lane [mailto:[EMAIL PROTECTED]] > > 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).
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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
