Rosser Schwarz <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
