On Thu, Jan 20, 2005 at 11:41:41AM +0200, Andrei Bintintan wrote:
> >Another possibility would be to create a functional index on datetime:
> >
> >CREATE INDEX user_action_date_idx ON user_action (date(datetime));
>
> GREAT!!! I thought it is possible but I didn't knew how to make such
> indexes. :))
See the "Indexes on Expressions" section in the "Indexes" chapter
of the documentation.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
