Horton

Re: create index with substr function

Rosser Schwarz <rosser.schwarz@gmail.com>

View thread
From: Rosser Schwarz <rosser.schwarz@gmail.com>
To: Ray <ray_siu@ge-ts.com.hk>
Cc: pgsql-performance@postgresql.org
Date: 2004-10-21T03:34:55Z
Lists: pgsql-performance 
while you weren't looking, Ray wrote:

> CREATE INDEX idx_doc_substr_doc_urn ON doc USING btree (SUBSTR(doc_urn,10));

CREATE INDEX idx_doc_substr_doc_urn ON doc USING btree ((SUBSTR(doc_urn,10)));

You need an additional set of parens around the SUBSTR() call.

/rls

-- 
:wq