Re: case insensitive matching

From: Tod McQuillin <devin(at)spamcop(dot)net>
To: Robert Kernell <kernell(at)sundog(dot)larc(dot)nasa(dot)gov>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: case insensitive matching
Date: 2000-10-03 16:43:19
Message-ID: Pine.LNX.4.21.0010040141330.1978-100000@glass
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 3 Oct 2000, Robert Kernell wrote:

> Hi. LIKE does case sensitive string matching. Is there an easy way to do case
> insensitive string matching?

Use "WHERE lower(a) LIKE lower(b)" or use one of the case insensitive
regexp operators instead
(http://www.postgresql.org/docs/aw_pgsql_book/node119.html#8125)
--
Tod McQuillin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2000-10-03 16:44:56 Re: alternative DB locations
Previous Message Ragnar Hakonarson 2000-10-03 16:41:28 RE: case insensitive matching