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