Richard Huxton <dev@archonet.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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
