Most efficient way of selecting by date?

From: Simon Willison <cs1spw(at)bath(dot)ac(dot)uk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Most efficient way of selecting by date?
Date: 2003-09-09 20:30:31
Message-ID: 3F5E3867.2060302@bath.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all,

I have a table which includes a field for the date and time an item was
added to it. What's the most efficient way of selecting all of the items
added on a specific date (this is a really basic question but I'm new to
Postgres)? Also, would it be worth putting an index on the date column
as most of my selects will be using it?

Thanks,

Simon

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Fromme 2003-09-09 20:48:11 Re: Modifying pg_shadow?
Previous Message Jason Hihn 2003-09-09 20:00:11 Re: Modifying pg_shadow?