Return-Path: mao
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA09407; Sat, 25 Jan 92 12:16:23 -0800
Message-Id: <9201252016.AA09407@postgres.Berkeley.EDU>
From: mao@postgres.Berkeley.EDU (Mike Olson)
Subject: Re: regex
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
In-Reply-To: Your message of Thu, 23 Jan 92 00:44:52 PST.
             <9201230844.AA06463@postgres.Berkeley.EDU> 
Date: Sat, 25 Jan 92 12:12:34 PST

In message <9201230844.AA06463@postgres.Berkeley.EDU> you write:

> Is there a mechanism when using the ~ operator to designate that the
> regular expression search should ignore case?

the ~ and !~ operators use the libc regex code.  off the top of my
head, i can't think of any simple way to write such an RE.  you could
do something like

	where f.a ~ "[Mm][Aa][Oo]"

if you have sufficient patience.
					mike olson
					postgres research group
					uc berkeley
					mao@cs.berkeley.edu