Richard Huxton <dev(at)archonet(dot)com> writes:
> But "like" without any wildcards should be the same as "=", but it isn't
> in the original post.
I'm too lazy to go look at the code right now, but I think that the
reduction of "x LIKE constant-pattern" to "x = constant-pattern" is
part of the LIKE index optimization code, which means it'd only get
done in C locale. We're missing a bet there perhaps.
regards, tom lane