Re: join removal - Mailing list pgsql-hackers

From Greg Stark
Subject Re: join removal
Date
Msg-id 407d949e0908090946g673d41dcx25405b2da58ac97c@mail.gmail.com
Whole thread Raw
In response to Re: join removal  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sun, Aug 9, 2009 at 5:19 PM, Tom Lane<tgl@sss.pgh.pa.us> wrote:
>
>> I am having a hard time wrapping my brain around what it means to have
>> multiple, incompatible notions of equality... any help appreciated!
>
> Well, for instance a complex-number datatype could have one btree
> opclass that sorts on absolute value (distance from 0,0) and another
> opclass that sorts on real part.  In the first case "equal" values would
> be members of the same circle around the origin, in the second case they
> are members of the same vertical line.

The example that came to mind for me was a case-insensitive btree
class for text.

--
greg
http://mit.edu/~gsstark/resume.pdf


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: revised hstore patch
Next
From: Bernd Helmle
Date:
Subject: Re: mixed, named notation support