Re: Domains and supporting functions

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Domains and supporting functions
Date: 2006-02-19 21:29:35
Message-ID: 20060219212935.GH1323@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Luke Lonergan 2006-02-19 21:29:51 Re: Pgfoundry and gborg: shut one down
Previous Message Douglas McNaught 2006-02-19 21:09:54 Re: postgresql query string length limit