Thread: Time Interval Question

Time Interval Question

From
Florian Steffen
Date:
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