On Monday 04 August 2003 04:29, Joseph Shraibman wrote: > Hmm. I didn't work for me. I'll try and figure this out. > > Tom Lane wrote: > > Joseph Shraibman <[EMAIL PROTECTED]> writes: > >>I notice in 7.3.3 the planner can't tell when a LIKE has no wildcards > >>and is in reality an '='. Is this an easy change to make?
Check your locale/encoding - you probably want "C" or similar for LIKE to use an index. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
