Indexing timestamp columns

From: Pedro Alves <pmalves(at)think(dot)pt>
To: PostGreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Indexing timestamp columns
Date: 2003-03-31 15:31:51
Message-ID: 20030331153151.GA22170@cosmos.inesc.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

Is it possible to make a timestamp column use a index in a query like
select foo from bar where timestamp <= smth?

It all seems ok when I use select foo from bar where timestamp = smth

Thanks
--
Pedro Miguel G. Alves pmalves(at)think(dot)pt
THINK - Tecnologias de Informação www.think.pt
Tel: +351 21 412 56 56 Av. José Gomes Ferreira
Fax: +351 21 412 56 57 nº 13 1495-139 ALGÉS

Responses

Browse pgsql-general by date

  From Date Subject
Next Message James Gregory 2003-03-31 15:47:44 Re: Referencing Problem/bug?
Previous Message Ezra Nugroho 2003-03-31 15:27:28 Re: [Pgreplication-general] DBMIRROR and INSERT transactions lose