Re: ILIKE - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: ILIKE
Date
Msg-id Pine.LNX.4.44.0302242018390.2108-100000@peter.localdomain
Whole thread Raw
In response to Re: ILIKE  (Josh Berkus <josh@agliodbs.com>)
Responses Re: ILIKE
Re: ILIKE
List 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



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Possibly inconsistent type casting logic
Next
From: Josh Berkus
Date:
Subject: Re: ILIKE