Re: indices and casts

Rosser Schwarz <rosser.schwarz@gmail.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