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

Re: create index with substr function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 02:59:14
Message-ID: 10774.1098327554@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
"Ray" <ray_siu(at)ge-ts(dot)com(dot)hk> writes:
> CREATE INDEX idx_doc_substr_doc_urn ON doc USING btree (SUBSTR(doc_urn,10));
> ERROR:  parser: parse error at or near "10" at character 68

This will work in 7.4, but not older releases.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: RayDate: 2004-10-21 03:11:05
Subject: Re: create index with substr function
Previous:From: Stephan SzaboDate: 2004-10-21 02:57:54
Subject: Re: create index with substr function

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