Re: LIKE without wildcard different from =

"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> To be clear, though, the problem isn't that it didn't turn a LIKE
> with no wildcard characters into an equality test, it's that it
> would have been three orders of magnitude faster (because of an
> available index with an opclass specification) if it had treated an
> equality test as a LIKE.

Ah.  Well, the real fix for that is also in 8.4: we got rid of the
separate ~=~ operator, so a text_pattern_ops index is now usable
for plain =.

            regards, tom lane