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: (view raw, whole thread or download thread mbox)
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
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-2018 The PostgreSQL Global Development Group