Tom Lane writes:
> Oh, I see. So the question still remains: can a MULTIBYTE-aware backend
> ever use a sort order different from strcmp() order? (That is, not as
> a result of LOCALE, but just because of the non-SQL-ASCII encoding.)
According to the code, no, because varstr_cmp() doesn't pay attention to
the multibyte status. Presumably strcmp() and strcoll() don't either.
> Actually there are more complicated cases that would depend on more
> features of the encoding than just sort order. Consider
>
> CREATE INDEX fooi ON foo (upper(field1));
>
> Operations involving this index will misbehave if the behavior of
> upper() ever differs between MULTIBYTE-aware and non-MULTIBYTE-aware
> code. That seems pretty likely for encodings like LATIN2...
Of course in the most general case this is a problem, because a function
can be implemented totally differently depending on any old #ifdef or
other external factors.
If the multibyte users think this check is okay, then I don't mind, since
it's usually what the users would want anyway. I'm just pointing out the
technical issues.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
