Re: interval origami

From: Adam Jensen <hanzer(at)riseup(dot)net>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: interval origami
Date: 2018-11-30 21:02:24
Message-ID: 6d32b24f-2d3e-df79-81d2-3b1abb8cc4b4@riseup.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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...

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Adam Jensen 2018-12-01 00:04:10 Re: interval origami
Previous Message Adam Jensen 2018-11-30 20:19:10 Re: interval origami