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

From elein
Subject Re: Domains and supporting functions
Date
Msg-id 20060219213641.GL15582@varlena.com
Whole thread Raw
In response to Re: Domains and supporting functions  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Domains and supporting functions
List pgsql-hackers
On Sun, Feb 19, 2006 at 10:29:35PM +0100, Martijn van Oosterhout wrote:
> 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?
> 

I'll show you my test case if you'll show me yours :)

~e


> 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: Andrew Dunstan
Date:
Subject: Re: Domains and supporting functions
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Domains and supporting functions