Skip site navigation (1) Skip section navigation (2)

Re: LIKE/ESCAPE implementation

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 (view raw or flat)
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
----------------------------------

In response to

pgsql-hackers by date

Next:From: Philip WarnerDate: 2000-08-05 07:22:50
Subject: Re: COALESCE implementation question
Previous:From: Philip WarnerDate: 2000-08-05 07:07:46
Subject: COALESCE implementation question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group