Richard Huxton <dev@xxxxxxxxxxxx> 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
