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

From Greg Stark
Subject Re: ERROR: FULL JOIN is only supported with merge-joinable
Date
Msg-id 87r756je1o.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: ERROR: FULL JOIN is only supported with merge-joinable  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ERROR: FULL JOIN is only supported with merge-joinable  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane <tgl@sss.pgh.pa.us> writes:

> Harco de Hilster <Harco.de.Hilster@ATConsultancy.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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Wisconsin Circuit Court Access (WCCA) on PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: multi-column aggregates