Hi,
I have seen postgresql is supporting time interval type. I'm planning to create
a database with time related content. Most queries will be in the form "all the
events in the period [a-date, another-date]".
Does postgresql support indexing on time interval ? In the past, I have used
such queries with other RDBMS and the performance on large dataset was pretty
bad due to the lack of "interval" indexing.
Florian