Doug, Yes, it does depend on the locale, you can get around this in 7.4 by building the index with smart operators
Dave On Thu, 2003-12-18 at 20:38, Doug McNaught wrote: > Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > > >> It appears that the optimizer only uses indexes for = clause? > > > > The optimizer will used indexes for LIKE clauses, so long as the > > clause is a prefix search, eg: > > > > SELECT * FROM test WHERE a LIKE 'prf%'; > > Doesn't this still depend on your locale? > > -Doug > > > ---------------------------(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 > > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster