Re: Domains and supporting functions - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Domains and supporting functions
Date
Msg-id 20060219212935.GH1323@svana.org
Whole thread Raw
In response to Re: Domains and supporting functions  (elein <elein@varlena.com>)
Responses Re: Domains and supporting functions
List pgsql-hackers
On Sun, Feb 19, 2006 at 12:59:35PM -0800, elein wrote:
> On Sun, Feb 19, 2006 at 07:57:42PM +0100, Martijn van Oosterhout wrote:
> > ORDER BY x ASC is a synonym for ORDER BY x USING >. That's the way it
> > is currently. To use ORDER BY by itself you need to call your operators
> > < and >.
> >
>
> This does not work where x is datatype foo with opclass foo_ops.
> In this case, it uses the text > instead of the foo >.

Huh? You must be doing something unusual because it does work normally.
Did you specify the opclass as the default for the type?

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: Douglas McNaught
Date:
Subject: Re: postgresql query string length limit
Next
From: "Luke Lonergan"
Date:
Subject: Re: Pgfoundry and gborg: shut one down