On 2005-12-31, Martijn van Oosterhout <kleptog(at)svana(dot)org> wrote: > You do bring up the possibility of secondary sort functions. Functions > which are not involved in testing for equality, but provide addition > sorting so that even in a case-insensetive sort, the different > variations in case appear together. "All variations are equal, but some > are more equal than others" type setup.
Doesn't this result in incorrect output in multi-column sorts?
i.e. if 'Foo' = 'foo', but for sorting purposes you always sort them with 'Foo' first, then a multicolumn sort of the following data: