Postgres Pro
Downloads
Home   >   mailing lists

Re: query by partial timestamp - Mailing list pgsql-general

From Michael Nolan
Subject Re: query by partial timestamp
Date
Msg-id CAOzAquJ+3Y2dMWiSCCrMNvFfp=sbHLeCZk5pGFHgcOAh8b1Y9A@mail.gmail.com
Whole thread Raw
In response to Re: query by partial timestamp  (Michael Nolan <htfoot@gmail.com>)
List pgsql-general
Tree view 
It is probably not the most efficient, but I often use this syntax,
which reads better.

Select ..... where col_type_timestamp::date between '2011-01-01' and
'2011-12-31'

This will use a timestamp index.
--
Mike Nolan

pgsql-general by date:

Previous
From: Michael Nolan
Date:
Subject: Re: query by partial timestamp
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: query by partial timestamp