Request for additional range operations like overlaps, strictly left of, and strictly right of

[mastor13]

We are interested in having some range operations which are supported in postgres but not yet in this package. Specifically the overlaps, strictly left of, and strictly right of operations.

Is there a plan to include those or a reason not to?

[martianboy]

Can you describe your use case a bit? Do you need the same operations in this library? Is there a specific syntax that's needed to be generated for those operations?

[mastor13]

We want to manipulate ranges in our typescript code in a way that matches the capabilities that postgresql supports (9.19. Range Functions and Operators)

You have provided the equivalent of "contains element" and "contains range" from the table above.
I was hoping to get a few more added.

Examples:

t(parse('[5, 10)', x => parseInt(x)).overlaps(parse('[10, 11]', x => parseInt(x))), false, '[5, 10).overlaps(\'[10, 11]\') is false')
t(parse('[5, 10]', x => parseInt(x)).overlaps(parse('[10, 11]', x => parseInt(x))), true, '[5, 10].overlaps(\'[10, 11]\') is true')
t(parse('[5, 10)', x => parseInt(x)).overlaps(parse('[8, 9]', x => parseInt(x))), true, '[5, 10).overlaps(\'[8, 9]\') is true')
t(parse('[8, 9)', x => parseInt(x)).overlaps(parse('[5, 10]', x => parseInt(x))), true, '[8, 9).overlaps(\'[5, 10]\') is true')
t(parse('[12, 20)', x => parseInt(x)).overlaps(parse('[10, 11]', x => parseInt(x))), false, '[12, 20).overlaps(\'[10, 11]\') is false')

And

t(parse('[5, 6)', x => parseInt(x)).strictlyLeftOf(parse('[9, 11)', x => parseInt(x))), true, '[5, 6).strictlyLeftOf(\'[9, 11)\') is true')
t(parse('[5, 10)', x => parseInt(x)).strictlyLeftOf(parse('[9, 11)', x => parseInt(x))), false, '[5, 10).strictlyLeftOf(\'[9, 11)\') is false')

t(parse('[5, 10)', x => parseInt(x)).strictlyRightOf(parse('[9, 11)', x => parseInt(x))), false, '[5, 10).strictlyRightOf(\'[9, 11)\') is false')
t(parse('[20, 30)', x => parseInt(x)).strictlyRightOf(parse('[9, 11)', x => parseInt(x))), true, '[20, 30).strictlyRightOf(\'[9, 11)\') is true')

overlaps is the one we need most, but for completeness we could add others, even including the union, intersection, difference, adjacent, etc.

[martianboy]

Got it. Sounds good. Feel free to submit a PR for this if you like. Otherwise I will try to find some time to do this soon.

[mastor13]

Greetings again, I was on vacation for a few weeks but back now and I wanted to let you know a colleague of mine and I would like to address this in our next sprint assuming you have not started on this?

[martianboy]

For sure, I'll be awaiting your PR then. Thank you!