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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

  From Date Subject
Next Message Ray 2004-10-21 03:11:05 Re: create index with substr function
Previous Message Stephan Szabo 2004-10-21 02:57:54 Re: create index with substr function