I am not familiar with ILIKE, but I suspect that if people are moving
from a platfrom on which it exists, or even creatingmulti-platform
applications, there may be a substancial amount of code that may use it.
Peter Eisentraut wrote:
>AFAICT, ILIKE cannot use an index. So why does ILIKE even exist, when
>lower(expr) LIKE 'foo' provides a solution that can use an index and is
>more standard, too?
>
>
>