Sender: owner-postgres95@postgres.Berkeley.EDU
Date: Wed, 8 Nov 1995 12:18:50 -0500 (EST)
From: Lou Sortman <lou@ncinfo.iog.unc.edu>
To: "Bryon S. Lape" <blape@utk.edu>
cc: Robert Patrick <Robert_Patrick@methi.ndim.edrc.cmu.edu>,
    postgres95@postgres.Berkeley.EDU
Subject: Re: (fwd) 
In-Reply-To: <9511081613.AA20931@aztec.lib.utk.edu>
Message-ID: <Pine.LNX.3.91.951108120339.195B-100000@lounix4.conc.tdsnet.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Resent-To: postgres95-redist
Resent-Date: Wed, 08 Nov 95 09:18:15 -0800
Resent-From: pglite
Resent-XMts: smtp

On Wed, 8 Nov 1995, Bryon S. Lape wrote:

> >
> >'(^|[^a-zA-Z0-9])user_word([^a-zA-Z1-9]|$)'
> 
>         Lou, I tried this and it did not work.

Hmmm.  I do, indeed, have egg on my xterm.
The parens confuse it, which is odd, since I thought that the regex functions
supported them.  Oh well, sorry to waste your time.  I guess you're stuck 
with the ORs.  The ~ syntax is subject to whatever regex functions you 
are using and so is inherently non-portable and not defined by SQL.  So, 
I imagine it would be possible to get ahold of a regex library that does 
handle parens and make this work.  I wonder how hard it would be to do 
this with the regex code from perl, so you could have patterns like \W 
instead of [^a-zA-Z0-9_]...

I vaguely remember some mention somewhere in the Ingres or Postgres docs 
about an inversion data type.  I might have been reading about it being 
dropped.  Is there a good way to set up inverted indexes in Postgres95?
Sometimes, WAIS is just too kludgey.  I guess it could be done with rules 
if they worked.

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