Re: case insensitive matching - Mailing list pgsql-general

From Tod McQuillin
Subject Re: case insensitive matching
Date
Msg-id Pine.LNX.4.21.0010040141330.1978-100000@glass
Whole thread Raw
In response to case insensitive matching  (Robert Kernell <kernell@sundog.larc.nasa.gov>)
List 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



pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: alternative DB locations
Next
From: "Adam Lang"
Date:
Subject: Re: case insensitive matching