So the answer is that ILIKE will not use indexes.
But using lower()/LIKE will give you exactly the same results. lower() forces all column data to lower case for the purposes of comparison.
-tfo
On Sep 21, 2004, at 4:07 PM, Kevin Murphy wrote:
On Sep 21, 2004, at 4:52 PM, Thomas F.O'Connell wrote: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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]