Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> Harco de Hilster <Harco(dot)de(dot)Hilster(at)ATConsultancy(dot)nl> writes:
> > What is the definition of a merge-joinable condition?
>
> Equality on a sortable datatype.
>
> > Can I create an type/operator that compares both records that is
> > considered merge-joinable?
>
> I think you could do something involving a time interval datatype that
> considers "overlap" as equality and does something reasonable for
> sorting non-overlapping intervals.
How could a non-transitive property ever be merge joinable though?
--
greg