Re: Does anybody use ORDER BY x USING y? - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Does anybody use ORDER BY x USING y?
Date
Msg-id 20050918200117.GD31394@svana.org
Whole thread Raw
In response to Re: Does anybody use ORDER BY x USING y?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Does anybody use ORDER BY x USING y?
List pgsql-hackers
On Sun, Sep 18, 2005 at 12:34:10PM -0700, Josh Berkus wrote:
> > All we lose is the ability to say USING [arbitrary op]. Does anybody
> > use this. Would people object to requiring the operator after USING to
> > be part of an operator class?
>
> Hmmm ... would this prevent the hackish workaround for case-insensitive sort?

Err, which hackish workaround would that be? The right solution is
citext which creates it's own operator class. This doesn't have
anything to do with functional indexes either.

I've been using Google to find any interesting use of the USING clause
but havn't found any yet.

Have a nice day,
--
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: Josh Berkus
Date:
Subject: Re: Does anybody use ORDER BY x USING y?
Next
From: Andrew Dunstan
Date:
Subject: Re: Does anybody use ORDER BY x USING y?