Skip site navigation (1) Skip section navigation (2)

Re: create index with substr function

From: Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)com>
To: Ray <ray_siu(at)ge-ts(dot)com(dot)hk>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: create index with substr function
Date: 2004-10-21 03:34:55
Message-ID: 37d451f704102020346fdbb855@mail.gmail.com (view raw or flat)
Thread:
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

In response to

Responses

pgsql-performance by date

Next:From: RayDate: 2004-10-21 03:37:26
Subject: Re: create index with substr function
Previous:From: RayDate: 2004-10-21 03:11:05
Subject: Re: create index with substr function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group