[GENERAL] Create Index on Date portion of timestamp

[Niederland]

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.


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/