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

From: Ying Lu <ying_lu(at)cs(dot)concordia(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Index creation question for expression (col1 || '-' || col2)
Date: 2005-07-08 16:08:41
Message-ID: 42CEA509.3090507@cs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Greetings,

A question about creating index for the following expression.

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

May I know is it possible and how I may create index for the expression
such as "col1 || '-' || col2" for a table please?

Thanks a lot,
Emi

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2005-07-08 16:12:23 Re: Make COUNT(*) Faster?
Previous Message PFC 2005-07-08 16:08:03 Re: Make COUNT(*) Faster?