Re: ILIKE

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