Thread: Index on a Function

Index on a Function

From
"Nathan Barnett"
Date:
I am trying to create an index on the result of a date_trunc('day',
columna).  When I try to create the index, I get a parse error near the '
before day.  I tried escaping the single quote by preceding it with a
backslash, but this gives an error saying that date_trunc(timestamp) doesn't
exist. Is there a work around to get this index created?  I'm using version
7.0.3 on FreeBSD 4.2-RELEASE.

--Nathan Barnett