You can use an index on an expression like "lower( col ) LIKE ... " as
long as the LIKE expression is left-anchored. See
http://www.postgresql.org/docs/7.4/static/indexes-expressional.html
-tfo
On Sep 21, 2004, at 1:16 PM, Kevin Murphy wrote:
I am pretty sure the answer is no, but ... is there any way to get
'ilike' to use an index? It seems like something that a lot of people
would want to do. Otherwise, should I just create redundant
case-mapped columns and use 'like'?
Thanks,
Kevin Murphy
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
