Re: ILIKE

Vince Vielhaber <vev@michvhf.com>

From: Vince Vielhaber <vev@michvhf.com>
To: Justin Clift <justin@postgresql.org>
Cc: Peter Eisentraut <peter_e@gmx.net>, Tom Lane <tgl@sss.pgh.pa.us>, Josh Berkus <josh@agliodbs.com>, <pgsql-hackers@postgresql.org>
Date: 2003-02-24T15:13:06Z
Lists: pgsql-hackers
On Tue, 25 Feb 2003, Justin Clift wrote:

> 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?

Why screw with it for the sake of screwing with it?

Vince.
-- 
 Fast, inexpensive internet service 56k and beyond!  http://www.pop4.net/
   http://www.meanstreamradio.com       http://www.unknown-artists.com
         Internet radio: It's not file sharing, it's just radio.