| From: | Denis Perchine <dyp(at)perchine(dot)com> |
|---|---|
| To: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>, Thomas Swan <tswan(at)olemiss(dot)edu> |
| Cc: | Hackers List <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: LIKE/ESCAPE implementation |
| Date: | 2000-08-05 07:08:58 |
| Message-ID: | 0008051410400G.00546@dyp.perchine.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> > Would their be anything like an ILIKE for a case insensitive like
> > search? Or maybe insensitive over text/char/varchar datatypes?
>
> What is ILIKE?
As far as I remember it was introduced in Oracle. (I may be mistaken)
> afaik it is not in SQL9x, so is there any reason to have
> that rather than the full regular expression case-insensitive operator
> ("~*") we already have?
Yes. They are. If you use RE you should escape lots of symbols. If you do not need
power of RE ILIKE is really the best choice.
--
Sincerely Yours,
Denis Perchine
----------------------------------
E-Mail: dyp(at)perchine(dot)com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philip Warner | 2000-08-05 07:22:50 | Re: COALESCE implementation question |
| Previous Message | Philip Warner | 2000-08-05 07:07:46 | COALESCE implementation question |