Postgres Pro
Downloads
Home   >   mailing lists

Re: expression index not used within function - Mailing list pgsql-general

From LPlateAndy
Subject Re: expression index not used within function
Date
Msg-id 1384426789728-5778319.post@n5.nabble.com
Whole thread Raw
In response to Re: expression index not used within function  (David Johnston <polobo@yahoo.com>)
List pgsql-general
Tree view 
Hi David,

Thanks, i can see the logic there. To place a constant in front, i tried
putting 'pc'||pcode in to the index and 'pc'||$1 in to the WHERE clause. It
had no effect - does the planner see this as a cheat and i need to actually
prefix the data in the tables?

Andy





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

pgsql-general by date:

Previous
From: walerina
Date:
Subject: Re: How to print out a mass of text messages from a Samsung smart phone easily?
Next
From: LPlateAndy
Date:
Subject: Re: expression index not used within function