Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> writes:
> DoMatch, which implements LIKE clearly thinks %% is %,
Careful: DoMatch thinks %% is a wildcard (ie, same as %), not literal %.
It's hard to say what our users think. If you'd written %% it would
indeed match a % --- but you'd have a problem with it matching other
stuff too. This might or might not be partially masked by the range
conditions inserted by the parser. (But how long have we been doing
that?)
regards, tom lane