5 ms·
How tied is the implementation to time specifically? Can it apply to other types (eg geometries) which can be subdivided?
by danielheath 4mo ago
How tied is the implementation to time specifically?
Can it apply to other types (eg geometries) which can be subdivided?
- pjungwir 4mo agoIn the Postgres version, you can use a rangetype or multirangetype over any base type (integers, inets, frammishes, etc). This is a generalization of SQL:2011, where PERIODs have to be on date/timestamp/timestamptz columns. I have ambitions to support non-range/multirange types as well, even user defined types, but I'll need to add a way for them to communicate a few things to core Postgres, like how to do intersect/contains/overlaps. I talked about that in my "roadmap" talk linked here if you're interested in details.
- danielheath 4mo agoThanks!