Postgres Pro
Downloads
Home   >   mailing lists

Indexing timestamp columns - Mailing list pgsql-general

From Pedro Alves
Subject Indexing timestamp columns
Date
Msg-id 20030331153151.GA22170@cosmos.inesc.pt
Whole thread Raw
Responses Re: Indexing timestamp columns  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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@think.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

pgsql-general by date:

Previous
From: Michael Loftis
Date:
Subject: Re: [Pgreplication-general] DBMIRROR and INSERT transactions lose
Next
From: Hervé Piedvache
Date:
Subject: Re: [Pgreplication-general] DBMIRROR and INSERT transactions lose time ...