Re: ILIKE

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?
>
>  
>