INDEXng date_trunc ...

From: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: INDEXng date_trunc ...
Date: 2001-11-22 14:41:53
Message-ID: 20011122094048.T64011-100000@earth.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ...

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Henshall, Stuart - WCP 2001-11-22 15:20:31 Re: ldap support
Previous Message Koen Antonissen 2001-11-22 13:30:15 "posttime" time DEFAULT now()