Re: like performance w/o wildcards. - Mailing list pgsql-general

Richard Huxton wrote:
> 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.

I'm using latin1.  Why should it make a difference?