Re: ILIKE

Josh Berkus <josh@agliodbs.com> writes:
> - Some other databases support ILIKE and it makes porting easier.

Which other ones?  I checked our archives and found that when we were
discussing adding ILIKE, it was claimed that Oracle had it.  But I can't
find anything on the net to verify that claim.  I did find that mSQL
(not MySQL) had it, as far back as 1996.  Nothing else seems to --- but
Google did provide a lot of hits on pages saying that ILIKE is a mighty
handy Postgres-ism ;-)

> Why this sudden urge to prune away perfectly useful operators?

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.
        regards, tom lane