Sender: owner-postgres95@postgres.Berkeley.EDU
X-Return-Path: andrew_yu
Received: from aztec.lib.utk.edu (AZTEC.LIB.UTK.EDU [128.169.206.31]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id NAA31619 for <postgres95@postgres.berkeley.edu>; Tue, 7 Nov 1995 13:24:25 -0800
Received: from LIBPC87.LIB.UTK.EDU by aztec.lib.utk.edu (5.x/2.8s-UTK)
	id AA09981; Tue, 7 Nov 1995 16:22:40 -0500
Message-Id: <9511072122.AA09981@aztec.lib.utk.edu>
X-Sender: bryon@128.169.206.31
X-Mailer: Windows Eudora Version 1.4.4
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Date: Tue, 07 Nov 1995 16:24:07 -0500
To: rp2y+@cs.cmu.edu
From: blape@utk.edu (Bryon S. Lape)
Subject: Re: (fwd) 
Cc: postgres95@postgres.Berkeley.EDU
Resent-To: postgres95-redist
Resent-Date: Tue, 07 Nov 95 13:24:27 -0800
Resent-From: pglite
Resent-XMts: smtp

>
> SELECT * 
>   FROM foo 
>  WHERE foo.bar ~ '.*[^a-zA-Z1-9]user_word[^a-zA-Z1-9].*'
>     OR foo.bar ~ 'user_word[^a-zA-Z1-9].*'
>     OR foo.bar ~ '.*[^a-zA-Z1-9]user_word'

        I tried the using the OR's and it returned too much.  Using the
first line of reg exp does seem to work though.


thanks,
bryon
--------------------------------------------------------------------------
Johnny, take my Bud Light....please.

Bryon S. Lape
e-mail: blape@utk.edu  WWW:http://aztec.lib.utk.edu/~bryon/


===============================================================================
  To unsubscribe from the Postgres95 mailing list, send mail with the subject
  line "DEL" to "postgres95-request@postgres.Berkeley.EDU". 
============  URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres95/  ===========
