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.
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 |