RE: case insensitive matching - Mailing list pgsql-general

From Ragnar Hakonarson
Subject RE: case insensitive matching
Date
Msg-id NEBBLIGKOLDMLCKMNBJMMEDHCBAA.ragnar@conquestnetwork.com
Whole thread Raw
In response to case insensitive matching  (Robert Kernell <kernell@sundog.larc.nasa.gov>)
List pgsql-general
use the '~*' operator, i.e., "attribute" ~* 'pattern'

Ragnar


-----Original Message-----
From: pgsql-general-owner@hub.org [mailto:pgsql-general-owner@hub.org]On
Behalf Of Robert Kernell
Sent: Tuesday, October 03, 2000 17:41
To: pgsql-general@postgresql.org
Subject: [GENERAL] case insensitive matching


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

Bob Kernell
Research Scientist
AS&M
email: kernell@sundog.larc.nasa.gov


pgsql-general by date:

Previous
From: Michael Ansley
Date:
Subject: OIDs
Next
From: Mart Käsper
Date:
Subject: Q : aborting requests ?