You can use an index on an expression like "lower( col ) LIKE ... " as long as the LIKE expression is left-anchored. See
Yes, I know that already. I wasn't talking about LIKE; I was talking about ILIKE. The data in the column is mixed-case.
-Kevin
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
