Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Well, I don't see that = would be significantly faster than LIKE with a
> no-wildcard string, so I don't see the value in having LIKE detect
> non-whildcard strings.
You forgot about indexing.
regards, tom lane