Tom Lane <tgl@xxxxxxxxxxxxx> writes: > Harco de Hilster <Harco.de.Hilster@xxxxxxxxxxxxxxxx> 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
