Peter Eisentraut wrote: > Bruce Momjian wrote: > > I have applied the following patch to mention non-C locales affect > > LIKE. > > I don't think it's accurate to say that there is a performance impact. > The only impact is that you need to create a different kind of index.
Well, there is a performance impact to using the locale functions, and you can't use ordinary indexes for LIKE, just special ones. Is there better text I should use? I used "performance impact" in the reference text to suggest there is an issue and they might want to read the locale section. -- 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 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly