Time Interval Question - Mailing list pgsql-general

From Florian Steffen
Subject Time Interval Question
Date
Msg-id 20001114122426.F29199@samaris
Whole thread Raw
List pgsql-general
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


pgsql-general by date:

Previous
From: Mickaël Jouanne
Date:
Subject: smallint to bigint
Next
From: Terényi Balázs
Date:
Subject: Win ODBC