| From: | Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com> |
|---|---|
| To: | Andras Balogh <abalogh(at)grafx(dot)ro> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pgsql DATE |
| Date: | 2000-04-26 14:41:39 |
| Message-ID: | 39070023.17BAF49@cupid.suninternet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)cupid(dot)suninternet(dot)com>
http://cupid.suninternet.com/~kleptog/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dale Anderson | 2000-04-26 15:01:33 | RE: unique row identifier data type exhausted . . . |
| Previous Message | Justin Banks | 2000-04-26 14:28:17 | Re: plpgsql FOR <select> LOOP question |