Horton

Re: ILIKE

Peter Eisentraut <peter_e@gmx.net>

View thread
From: Peter Eisentraut <peter_e@gmx.net>
To: Josh Berkus <josh@agliodbs.com>
Cc: PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2003-02-24T19:19:34Z
Lists: pgsql-hackers 
Josh Berkus writes:

> 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.

-- 
Peter Eisentraut   peter_e@gmx.net