Postgres Pro
Downloads
Home   >   mailing lists

Re: Index creation question for expression (col1 || '-' || col2) - Mailing list pgsql-sql

From Tom Lane
Subject Re: Index creation question for expression (col1 || '-' || col2)
Date
Msg-id 23332.1120839304@sss.pgh.pa.us
Whole thread Raw
In response to Index creation question for expression (col1 || '-' || col2)  (Ying Lu <ying_lu@cs.concordia.ca>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Make COUNT(*) Faster?
Next
From: Michael Fuhr
Date:
Subject: Re: Index creation question for expression (col1 || '-' || col2)