Re: interval origami - Mailing list pgsql-sql

From Adam Jensen
Subject Re: interval origami
Date
Msg-id 6d32b24f-2d3e-df79-81d2-3b1abb8cc4b4@riseup.net
Whole thread Raw
In response to Re: interval origami  (Adam Jensen <hanzer@riseup.net>)
Responses Re: interval origami
Re: interval origami
List pgsql-sql
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...


pgsql-sql by date:

Previous
From: Adam Jensen
Date:
Subject: Re: interval origami
Next
From: Adam Jensen
Date:
Subject: Re: interval origami