Removing SORTFUNC_LT/REVLT - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Removing SORTFUNC_LT/REVLT
Date
Msg-id 20051228220622.GK24400@svana.org
Whole thread Raw
Responses Re: Removing SORTFUNC_LT/REVLT
List pgsql-hackers
Greetings everybody,

As part of the changes I would like relating to collations, the two
sort options in inlineApplySortFunction() using only a less-than
operator may become unsupportable. This has been indirectly discussed
before [1] and no-one seemed to have an issue with it then. Internally
nothing in PostgreSQL needs it, but if we want to keep supporting that
ORDER BY ... USING clause it would have to stay.

The issue is whether anything you want to ORDER BY needs to be
described by an B-tree operator class, and hence have a real sort
function.

1. Do people have any problems with this?
2. Would a patch for this be accepted seperate from the whole collation
stuff?

Have a nice day,

[1] http://archives.postgresql.org/pgsql-hackers/2005-09/msg00784.php
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

pgsql-hackers by date:

Previous
From: Volkan YAZICI
Date:
Subject: FATAL: failed to initialize TimeZone to "UNKNOWN"
Next
From: Tom Lane
Date:
Subject: Re: localization problem (and solution)