Re: Index creation question for expression (col1 || '-' || col2)

Ying Lu <ying_lu@cs.concordia.ca> writes:
> A question about creating index for the following expression.

> CREATE INDEX idx_t1 ON test (col1 || '-' || col2);

You need more parentheses:

CREATE INDEX idx_t1 ON test ((col1 || '-' || col2));
        regards, tom lane