Lee Asher can’t be limited to a single point:
Our Part I query used the following WHERE clause:
WHERE tsrange(o.start_time, o.end_time) && tsrange(p.enter, p.leave)The “
tsrange()” functions return timestamp ranges. But overlap queries aren’t limited to timestamps; they can be constructed from integers and floating-point values too. Imagine an arbitrage database that tracks the minimum and maximum price paid for a commodity.
Read on for examples of other types of ranges, preventing range intersection, and more.