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 <jks@selectacast.net> 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