Re: expression index not used within function - Mailing list 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.