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