Re: expression index not used within function

From: LPlateAndy <andy(at)centremaps(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: expression index not used within function
Date: 2013-11-18 16:23:12
Message-ID: 1384791792963-5778927.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Just wondering what kind of execute statement (within a function) i should
use to force the planner to use the index for the following?:

SELECT pcode searchmatch, geometry FROM postcode
WHERE (replace(lower(pcode), ' '::text, ''::text)) LIKE
(replace((lower($1)::text),' '::text,''::text)||'%'::text)

Thanks

Andy

--
View this message in context: http://postgresql.1045698.n5.nabble.com/expression-index-not-used-within-function-tp5778236p5778927.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Janek Sendrowski 2013-11-18 16:32:29 Re: Regex files are missing
Previous Message Tom Lane 2013-11-18 16:10:17 Re: Regex files are missing