Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)com> writes:
> Is it possible to do something functionally equivalent to "CREATE
> INDEX name ON table USING btree(column::date)"? That statement yields
> a syntax error on the "::".
CREATE INDEX name ON table USING btree((column::date))
See the docs concerning indexes on expressions (formerly called
functional indexes). The parens are needed to avoid syntactic ambiguity
associated with the optional opclass name ...
regards, tom lane