RE: case insensitive matching

From: "Ragnar Hakonarson" <ragnar(at)conquestnetwork(dot)com>
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:41:28
Message-ID: NEBBLIGKOLDMLCKMNBJMMEDHCBAA.ragnar@conquestnetwork.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


use the '~*' operator, i.e., "attribute" ~* 'pattern'

Ragnar

-----Original Message-----
From: pgsql-general-owner(at)hub(dot)org [mailto:pgsql-general-owner(at)hub(dot)org]On
Behalf Of Robert Kernell
Sent: Tuesday, October 03, 2000 17:41
To: pgsql-general(at)postgresql(dot)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(at)sundog(dot)larc(dot)nasa(dot)gov

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tod McQuillin 2000-10-03 16:43:19 Re: case insensitive matching
Previous Message Robert Kernell 2000-10-03 16:41:13 case insensitive matching