On Sun, 2003-02-23 at 23:31, Tom Lane wrote:
> 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 ;-)
Isn't MySQL case insensitive by default? I know the ='s operator is
(was?)
'a' = 'A'
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
