| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: ILIKE |
| Date: | 2003-02-24 12:04:46 |
| Message-ID: | 1046088285.84130.248.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sun, 2003-02-23 at 23:31, Tom Lane wrote:
> Josh Berkus <josh(at)agliodbs(dot)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(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christoph Haller | 2003-02-24 12:22:56 | REPEATED INSERT INTO ... |
| Previous Message | John Cochran | 2003-02-24 06:23:52 | Re: regression failure - horology |