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 LAA27444 for <postgres95@nobozo.cs.berkeley.edu>; Tue, 7 Nov 1995 11:15:57 -0800
Received: from LIBPC87.LIB.UTK.EDU by aztec.lib.utk.edu (5.x/2.8s-UTK)
	id AA06579; Tue, 7 Nov 1995 14:14:39 -0500
Message-Id: <9511071914.AA06579@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 14:15:40 -0500
To: rp2y+@cs.cmu.edu, jarnott@bridge.com,
    postgres95@postgres.Berkeley.EDU
From: blape@utk.edu (Bryon S. Lape)
Subject: Re: (fwd) 
Resent-To: postgres95-redist
Resent-Date: Tue, 07 Nov 95 11:16:04 -0800
Resent-From: pglite
Resent-XMts: smtp


>
>For exclusive, full-word only matching, you do something like this:
>
>SELECT * 
>  FROM foo 
> WHERE foo.bar ~ '[^a-zA-Z1-9]user_word[^a-zA-Z1-9]'

        I tried this and it does not work for whole word searching.  In
fact, it returns nothing.  Am I missing something??
        I tried it with fields that contained a single value (call number)
and a word within a multi-word field (title) and neither returned anything.


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/  ===========