Re: like performance w/o wildcards.

Joseph Shraibman <jks@selectacast.net> writes:
>> The index is for non-LIKE comparisons, like = and >.
>>
> My point is what is the difference?  If the index is done char by char then LIKE ought to
> be able to use the index to find 'F*', no matter what the locale is.  What can't you
> figure out what is before/after a given char?  Don't you have that information?  Don't you
> need it to create the index in the first place?

<yawn>  Read the archives.  We would love to use locale-sorted indexes
for LIKE, but we *can't*.  There are too many bizarre sorting rules.
(Hint: almost no locale does its sorting purely "char by char".)

            regards, tom lane