Re: Date indexing - Mailing list pgsql-sql

From Ian Cass
Subject Re: Date indexing
Date
Msg-id 001b01c1eacf$aeaae610$6602a8c0@salamander
Whole thread Raw
In response to Date indexing  ("Ian Cass" <ian.cass@mblox.com>)
List 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



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Date indexing
Next
From: "Ian Cass"
Date:
Subject: Re: Date indexing