On Sun, Feb 19, 2006 at 01:36:41PM -0800, elein wrote:
> 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 :)
Ok, here's a quick example I whipped up and if you run it it clearly
shows it's using the comparison function from the operator class.
http://svana.org/kleptog/temp/text2.example
It basically replicates the entire infrastructure for the text type as
a new type, "text2" so there's planty of scope for confusion, but
postgresql correctly picks the right function.
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.