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.
pgpA0lcLWPQHn.pgp
Description: PGP signature