Re: pgsql DATE

Поиск
Список
Период
Сортировка
От Charles Tassell
Тема Re: pgsql DATE
Дата
Msg-id 4.2.0.58.20000426150522.00aabe40@mailer.isn.net
обсуждение исходный текст
Ответ на Re: pgsql DATE  (Martijn van Oosterhout <kleptog@cupid.suninternet.com>)
Ответы Re: pgsql DATE  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-general
Might want to try date BETWEEN '01/4/2000' AND '01/5/2000' as well,  this
is probably optimized better (although I may be wrong.)

At 11:41 AM 4/26/00, Martijn van Oosterhout wrote:
>Andras Balogh wrote:
> > So i am looking a date type that would allow me to do the following
> with one
> > (or a few) query
> > (and to be fast too):
> > -select all records for a given month
> > -select the count of records where the hour is 14.
> > -select  all the records from the 7th week.
> > -select count of records  where the day of the week is Sunday.
> > etc.
>
>How about you write your queries like:
>
>date >= '01/4/2000' and date < '01/5/2000'
>
>or equivalent. It allows use of the index but works the same.
>Except for the day is Sunday though...
>--
>Martijn van Oosterhout <kleptog@cupid.suninternet.com>
>http://cupid.suninternet.com/~kleptog/


В списке pgsql-general по дате отправления:

Предыдущее
От: Jim Mercer
Дата:
Сообщение: pgsql/php3/apache authentication
Следующее
От: Charles Tassell
Дата:
Сообщение: RE: too many clients - Error message