From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Domains and supporting functions |
Date: | 2006-02-19 22:34:21 |
Message-ID: | 20060219223421.GJ1323@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(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 | uwcssa | 2006-02-19 23:19:44 | Re: postgresql query string length limit |
Previous Message | Albert Chin | 2006-02-19 22:29:32 | Re: Fix to CVE-2006-0553 for 8.1.1 |