Comment

Comment by ccorcos

I think these numerical constraints are because range trees use numerical averages to construct themselves. This is important for OVERLAPS queries common with dates. But you could construct interval tree indexes lexicographically using text but they are quite uncommon. It’s something I’ve experimented with a decent amount though.

https://github.com/ccorcos/database-experiments/blob/master/...

parent ccorcos 1 year ago

No comments yet

Be the first to share your thoughts.

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton