Re: Create Index on Date portion of timestamp

On Thu, Oct 12, 2006 at 06:40:22PM -0700, Niederland wrote:
> I am using postgresql 8.1.4.
>
> Is there anyway to create an index equivalent to:
> CREATE INDEX i1 ON t1 USING btree (ts::Date);
>
> So that indexes are used for queries when the field is cast to a date.

I didn't try it, but you ought to be able to create a functional
index on the to_date() of the column. I don't know if that will
solve your cast issue, but you could rewrite the CAST into the
to_date form to get around that.

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
"The year's penultimate month" is not in truth a good way of saying
November.
--H.W. Fowler