See the FAQ item about index usage. You have to anchor the start only. ---------------------------------------------------------------------------
[EMAIL PROTECTED] wrote: > > We require ~* syntax for that, or upper()/lower(). > > Slowly the light dawns! > > If I anchor a ~ search on both ends, it is the same search as =. > > Duh! > > I converted the prototype over to use ~ and it is running much faster. > I'll try to do some detailed timings against MySQL tonight. > -- > Mike Nolan > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (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