Re: like performance w/o wildcards.

Joseph Shraibman <jks@selectacast.net> writes:
> What percentage of locales have this problem?  Does latin1 have this problem?

Latin1 is an encoding, not a locale.  To a first approximation, I'd say
*all* non-C locales have some kind of sorting funny business.

> And what about my original idea, can LIKE be turned into an = when there are no wildcards?

It does ... if the index-conversion optimization is enabled at all.  Not
sure it's worth special-casing the '=' case otherwise.

            regards, tom lane