postgres-range-operations

A simple typescript implemtation of postgres range operations as described here.

NumRange

1const range: NumRange = NumRange.fromString("(1,2]");
2
3range.upper() // 2
4range.lower() // 1
5
6range.upperInc() // true
7range.lowerInc() // false
8
9range.upperInf() // false
10range.lowerInf() // false
11
12range.equals(NumRange.fromString("(1,2]")) // true
13
14range.notExtLeftOf(NumRange.fromString("(0,2]")) // true
15range.notExtRightOf(NumRange.fromString("(1,3)")) // true
16
17range.containsRange(NumRange.fromString("(1,2)")) // true
18range.containsPoint(2) // true
19
20// bounds can be infinity (i.e (,) = (-Infinity,Infinity))
21range.overlaps(NumRange.fromString("(,)")) // true
22
23// ranges can also be empty 
24// ex: (3,3) = empty, bounds will be stored as NaN
25range.overlaps(NumRange.fromString("empty")) // false
26
27range.strictlyLeftOf(NumRange.fromString("(2,3)")) // true
28range.strictlyRightOf(NumRange.fromString("(,1]")) // true
29
30range.adjacentTo(NumRange.fromString("(2,3)")) // true
31
32range.union(NumRange.fromString("(,1]")) // (,2]
33
34range.union(NumRange.fromString("(3,4)")) // error - cannot union disjoint ranges
35
36range.intersection(NumRange.fromString("(1,2)")) // (1,2)
37range.intersection(NumRange.fromString("(0,1])")) // empty
38
39range.difference(NumRange.fromString("(0,1.5]")) // (1.5,2]
40range.difference(NumRange.fromString("(0,100)")) // error - cannot difference to disjoint ranges
41
42// construct without fromString
43new NumRange(1,2, Range.FLAG_LOWER_INC | Range.FLAG_UPPER_INC) // [1,2]
44new NumRange(-Infinity,2) // (,2)

DateRange

1const range: DateRange = DateRange.fromString("(10-07-2001,02-14-2025)");

Custom Range Types

You can create custom range types by extending Range<T>.