Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group