Horton

Re: ILIKE

Josh Berkus <josh@agliodbs.com>

View thread
From: Josh Berkus <josh@agliodbs.com>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2003-02-24T19:22:08Z
Lists: pgsql-hackers 
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