Peter,
> > 4) It's just as indexible (or not indexable) as regexp comparisons, and
> > easier to understand for users from the Microsoft world than regexp.
>
> ILIKE is not indexible at all. Other forms of pattern comparisons are at
> least indexible sometimes.
And how is ~* indexable?
--
Josh Berkus
Aglio Database Solutions
San Francisco