Most efficient way of selecting by date?

Поиск
Список
Период
Сортировка
От Simon Willison
Тема Most efficient way of selecting by date?
Дата
Msg-id 3F5E3867.2060302@bath.ac.uk
обсуждение исходный текст
Ответы Re: Most efficient way of selecting by date?  (Bruno Wolff III <bruno@wolff.to>)
Re: Most efficient way of selecting by date?  (Ron Johnson <ron.l.johnson@cox.net>)
Список 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 по дате отправления:

Предыдущее
От: Jason Hihn
Дата:
Сообщение: Re: Modifying pg_shadow?
Следующее
От: Oliver Fromme
Дата:
Сообщение: Re: Modifying pg_shadow?