Re: extended operator classes vs. type interfaces - Mailing list pgsql-hackers

From Yeb Havinga
Subject Re: extended operator classes vs. type interfaces
Date
Msg-id 4BC0A1AE.10602@gmail.com
Whole thread Raw
In response to Re: extended operator classes vs. type interfaces  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: extended operator classes vs. type interfaces  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Jeff Davis wrote:
> To give some context, I started a thread a while ago:
>
> http://archives.postgresql.org/pgsql-hackers/2009-10/msg01403.php
>   
Interesting, a join type for overlaps, which makes me think a bit of the 
staircase join for pre-post coordinates. However, does a join operator 
type need certain kinds of properties of the operator involved, e.g. 
being commutative, transitive etc? Else the join reordering fails. The 
latter fails for the overlap operator.

regards,
Yeb Havinga



pgsql-hackers by date:

Previous
From: Jean-Gérard Pailloncy
Date:
Subject: Virtual Private Database
Next
From: Robert Haas
Date:
Subject: Re: extended operator classes vs. type interfaces