Olivier PRENANT <ohp(at)pyrenet(dot)fr> writes:
> CREATE INDEX deb ON xxxx USING btree (date(timestamp coll) date_ops);
> on 7.2 I have an error message saying that functrional indexes must but
> made ISCACHABLE.
See previous discussion of this identical problem. The fact is that
such an index is dangerous, because it depends on the timezone setting.
You might want to make the underlying column be timestamp without time
zone.
regards, tom lane