On Sun, 2003-02-23 at 23:31, Tom Lane wrote: > Josh Berkus <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> PGP Key: http://www.rbt.ca/rbtpub.asc
signature.asc
Description: This is a digitally signed message part
