Re: ILIKE - Mailing list pgsql-hackers

From Justin Clift
Subject Re: ILIKE
Date
Msg-id 3E5A2E98.6060207@postgresql.org
Whole thread Raw
In response to Re: ILIKE  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: ILIKE
List pgsql-hackers
Peter Eisentraut wrote:
> Tom Lane writes:
> 
>>My feeling too.  Whatever you may think of its usefulness, it's been a
>>documented feature since 7.1.  It's a bit late to reconsider.
> 
> It's never too late for new users to reconsider.  It's also never too late
> to change your application of performance is not satisfactory.
> 

Well, ILIKE has been a feature for quite some time and the amount of 
negative feedback we've been receiving about upgrade problems makes me 
feel that _removing_ it would be detrimental.  (i.e. broken applications)

As an alternative to _removing_ it, would a feasible idea be to 
transparently alias it to something else, say a specific type of regex 
query or something?

Regards and best wishes,

Justin Clift

-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi



pgsql-hackers by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: ILIKE
Next
From: Tom Lane
Date:
Subject: Re: REPEATED INSERT INTO ...