> Too bad... that was my idea, that it would somehow be aware that it is 
> equivalent to lower() like. It really is, isn't it? I would have though 
> they where synonymous. If not, makes ILIKE kind of unusable, at least 
> unless you're pretty certain the field will never indexed.

Yup.   I use it mostly for lookups in reference lists with < 100 items, where 
an index doesn't matter.

-Josh Berkus
 Aglio Database Solutions
 San Francisco

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


Reply via email to