Re: ILIKE - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: ILIKE
Date
Msg-id 200302241122.08271.josh@agliodbs.com
Whole thread Raw
In response to Re: ILIKE  (Peter Eisentraut <peter_e@gmx.net>)
List 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


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: ILIKE
Next
From: Tom Lane
Date:
Subject: Re: Outdated example in documentation