Re: interval origami

Adam Jensen <[email protected]> Fri, 30 Nov 2018 16:02:24 -0500

Newsgroups	gmane.comp.db.postgresql.sql
Message-ID	<[email protected]>

On 11/30/18 3:19 PM, Adam Jensen wrote:
> The 'numrange' type with the 'overlaps' and 'intersection' operators
> seem to cover the fundamental computations in a very natural way.

Actually, those operators might not be entirely sufficient. Given two
ranges like this:

10.0|39.0|interesting
15.0|21.0|fail

Something like the negative or inverse of the intersection is needed:

10.0|15.0|interesting
21.0|39.0|interesting

Hmm...