> But what about ILIKE. It does not take advantage of indices built with 
> lower():

Nope.  If you want to use a functional index, you'll need to use the function 
when you call the query.   ILIKE is not somehow aware that it is equivalent 
to lower().

-Josh Berkus
 Aglio Database Solutions
 San Francisco

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to