ILIKE - Mailing list pgsql-hackers

From Peter Eisentraut
Subject ILIKE
Date
Msg-id Pine.LNX.4.44.0302220134210.2067-100000@peter.localdomain
Whole thread Raw
Responses Re: ILIKE
List pgsql-hackers
AFAICT, ILIKE cannot use an index.  So why does ILIKE even exist, when
lower(expr) LIKE 'foo' provides a solution that can use an index and is
more standard, too?

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Simplifying timezone support
Next
From: Joe Conway
Date:
Subject: regression failure - horology