Skip site navigation (1) Skip section navigation (2)


From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Removing SORTFUNC_LT/REVLT
Date: 2005-12-29 09:43:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
On Wed, Dec 28, 2005 at 07:38:36PM -0500, Tom Lane wrote:
> Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> > 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.
> I think it's reasonable to remove that feature, *after* we provide
> a workable substitute.  So, "no" to both questions ...

Hmm. By feature I assume you mean "ORDER BY ... USING" (which no-one
could find an example of) and not "requiring the operator to be part of
an opclass".

The only people affected would be people who defined a less-than
operator but no operator class, which you said yourself would probably
just be encouraging programmer lazyness. I wasn't suggesting removing
the ORDER BY ... USING syntax, just these two options from the sorting

In fact, I don't think we ever need to remove the syntax, just as long
as the operator is part of an operator class, it'll be fine.

Have a nice day,
Martijn van Oosterhout   <kleptog(at)svana(dot)org>
> 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.

In response to


pgsql-hackers by date

Next:From: Dave PageDate: 2005-12-29 10:18:12
Subject: FW: PGBuildfarm member snake Branch HEAD Status changed from OK to Make failure
Previous:From: Magnus HaganderDate: 2005-12-29 09:34:51
Subject: Re: localization problem (and solution)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group