Re: Removing SORTFUNC_LT/REVLT - Mailing list pgsql-hackers

From Andrew - Supernews
Subject Re: Removing SORTFUNC_LT/REVLT
Date
Msg-id slrndr83us.1an.andrew+nonews@atlantis.supernews.net
Whole thread Raw
In response to Removing SORTFUNC_LT/REVLT  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Removing SORTFUNC_LT/REVLT
List pgsql-hackers
On 2005-12-29, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Well, no, that's not the problem: the problem is that you should be able
> to specify ORDER BY any sort ordering that the system can deal with, and
> the USING syntax is in fact too impoverished to do that.  What if the
> mentioned operator is in more than one operator class?  I believe that
> ATM the code makes a random choice of which opclass' sort function to
> use, which pretty much sucks.

Does it matter? How would the same operator specify different orderings
in different operator classes, given that it must be a strict weak ordering
for sorting to even work, and such an ordering is completely determined by
either one of its greater-than/less-than operators?

-- 
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services


pgsql-hackers by date:

Previous
From: Qingqing Zhou
Date:
Subject: Re: EINTR error in SunOS
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Removing SORTFUNC_LT/REVLT