Re: SQL timestamp to date cast

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/