Most efficient way of selecting by date? - Mailing list pgsql-novice

From Simon Willison
Subject Most efficient way of selecting by date?
Date
Msg-id 3F5E3867.2060302@bath.ac.uk
Whole thread Raw
Responses Re: Most efficient way of selecting by date?
Re: Most efficient way of selecting by date?
List 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


pgsql-novice by date:

Previous
From: Jason Hihn
Date:
Subject: Re: Modifying pg_shadow?
Next
From: Oliver Fromme
Date:
Subject: Re: Modifying pg_shadow?