| From: | Andrew - Supernews <andrew+nonews(at)supernews(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Removing SORTFUNC_LT/REVLT |
| Date: | 2006-01-01 07:48:56 |
| Message-ID: | slrndrf2b8.2iki.andrew+nonews@atlantis.supernews.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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:
('Foo',1)
('foo',2)
('Foo',3)
would produce the wrong output, no?
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Qingqing Zhou | 2006-01-01 07:52:48 | Re: EINTR error in SunOS |
| Previous Message | Greg Stark | 2006-01-01 07:36:22 | Re: EINTR error in SunOS |