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