Tom Lane writes:
> On the other hand, LIKE *is* multibyte aware. So the hypothetical
> non-locale-aware comparison operators would need to be aware of
> multibyte character sets even though not aware of locale. And the
> "add one" operator that we postulated for the LIKE index optimization
> needs to be able to increment a multibyte character.
Both of these are not hard if you know how strcmp operates. It would also
be irrelevant whether "add one" to a multibyte character yields another
valid multibyte character. strcmp doesn't care.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter