INDEXng date_trunc ... - Mailing list pgsql-sql

In v7.2, how does one index a function?

CREATE INDEX hourly_stats_day         ON hourly_stats      USING btree ( DATE_TRUNC('day',runtime) ) ;

Gives me:

ERROR:  parser: parse error at or near "'"


so I'm obviously doing it wrong :)

Thanks ...