| From: | "Ian Cass" <ian(dot)cass(at)mblox(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Date indexing |
| Date: | 2002-04-23 14:03:44 |
| Message-ID: | 001b01c1eacf$aeaae610$6602a8c0@salamander |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
> Don't use text, use a date.
Thanks, I'll try that.
> One might also wonder why you're not just storing the column as type
> date rather than timestamp in the first place, if you're certain you
> do not need finer resolution.
Because in other instances, I do need the extra resolution. This is a high
level overview report I'm trying to write.
--
Ian Cass
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Cass | 2002-04-23 14:07:49 | Re: Date indexing |
| Previous Message | Chris Gamache | 2002-04-23 14:02:28 | Suggestions for Large DB Dump/Reload |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Cass | 2002-04-23 14:07:49 | Re: Date indexing |
| Previous Message | Tom Lane | 2002-04-23 13:56:38 | Re: Date indexing |