Index on a Function - Mailing list pgsql-general

From Nathan Barnett
Subject Index on a Function
Date
Msg-id MHEJIGLIMNDMHOMFOJDEMEFLCCAA.natebiz@cfl.rr.com
Whole thread Raw
List pgsql-general
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


pgsql-general by date:

Previous
From: Jeff Eckermann
Date:
Subject: Help with SQL Function
Next
From: gravity@node10065.a2000.nl
Date:
Subject: Re: PHP and PostgreSQL