Re: Date indexing

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

In response to

Browse pgsql-general by date

  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

Browse pgsql-sql by date

  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