Alvaro Herrera wrote: > On Mon, Jun 06, 2005 at 10:11:15PM -0400, Bruce Momjian wrote: > > Greg Stark wrote: > > > > Yes it's true that on some OSes it wouldn't be tolerably efficient but on > > > glibc it's more than tolerable. If better solutions (strxfrm_l) become > > > available at some point in the future then it would be about as efficient > > > as > > > it could be on platforms where those features are available. > > > > There are some things I think ICU can fix for us like indexing non-C > > localed columns. > > Huh, we already do that, don't we?
Sorry, I meant LIKE index usage for non-C columns. We can do that now with a special LIKE indexing method, but this would allow normal indexes to work. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend