Re: ERROR: FULL JOIN is only supported with merge-joinable - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: FULL JOIN is only supported with merge-joinable
Date
Msg-id 9946.1142281693@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: FULL JOIN is only supported with merge-joinable  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Greg Stark <gsstark@mit.edu> writes:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
>> 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?

Um, good point.  So it couldn't be "overlaps" in the normal sense of the
word.  But given that he's mostly concerned about cases where one end is
+infinity, it might be possible to devise a consistent semantics that
works.

            regards, tom lane

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: multi-column aggregates
Next
From: Berend Tober
Date:
Subject: Re: multi-column aggregates