Postgres Pro
Downloads
Home   >   mailing lists

Re: create index with substr function - Mailing list pgsql-performance

From Rosser Schwarz
Subject Re: create index with substr function
Date
Msg-id 37d451f704102020346fdbb855@mail.gmail.com
Whole thread Raw
In response to create index with substr function  ("Ray" <ray_siu@ge-ts.com.hk>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: create index with substr function
Next
From: "Ray"
Date:
Subject: Re: create index with substr function