Re: Removing SORTFUNC_LT/REVLT
От | Andrew - Supernews |
---|---|
Тема | Re: Removing SORTFUNC_LT/REVLT |
Дата | |
Msg-id | slrndrf2b8.2iki.andrew+nonews@atlantis.supernews.net обсуждение исходный текст |
Ответ на | Removing SORTFUNC_LT/REVLT (Martijn van Oosterhout <kleptog@svana.org>) |
Ответы |
Re: Removing SORTFUNC_LT/REVLT
|
Список | pgsql-hackers |
On 2005-12-31, Martijn van Oosterhout <kleptog@svana.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: ('Foo',1) ('foo',2) ('Foo',3) would produce the wrong output, no? -- Andrew, Supernews http://www.supernews.com - individual and corporate NNTP services
В списке pgsql-hackers по дате отправления: