Re: LIKE should use index when condition doesn't include

Palle,

> 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