Re: ILIKE

From: Justin Clift <justin(at)postgresql(dot)org>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: ILIKE
Date: 2003-02-24 14:39:20
Message-ID: 3E5A2E98.6060207@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • Re: ILIKE at 2003-02-24 12:32:44 from Peter Eisentraut

Responses

  • Re: ILIKE at 2003-02-24 15:13:06 from Vince Vielhaber

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-02-24 15:02:15 Re: REPEATED INSERT INTO ...
Previous Message Vince Vielhaber 2003-02-24 12:38:34 Re: ILIKE