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: (view raw or whole thread)
Lists: pgsql-general

  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

Pedro Miguel G. Alves           pmalves(at)think(dot)pt
THINK - Tecnologias de Informação
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

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-2015 The PostgreSQL Global Development Group