Forum OpenACS Q&A: OpenFTS as searching on partial words

Collapse
1: OpenFTS as searching on partial words
Posted by Lars Pind on 06/06/03 06:50 PM
I found this old discussion thread that says OpenFTS can't search on partial words:

http://sourceforge.net/forum/forum.php?thread_id=144823&forum_id=97445

But the reply is about 18 months old, so I figured I'd see if anyone here would know if things had changed since then?

/Lars

Collapse
2: Re: OpenFTS as searching on partial words (response to 1)
Posted by Neophytos Demetriou on 06/06/03 07:19 PM
Lars, the newest tsearch module supports boolean expressions search (if that's what you mean by partial words) but they are expensive w.r.t the default behavior. IMHO, stemmed and dashed words searching should be enough for most cases but I suppose that you have a specific use case where boolean expressions are necessary. I'm gonna be out of town for the weekend, but I'll get back to this as soon as I'm back.
Collapse
3: Re: OpenFTS as searching on partial words (response to 1)
Posted by Lars Pind on 06/10/03 11:47 AM
No, didn't mean boolean search. I meant seraching for "busi" would find "business", for example.

/Lars

Collapse
4: Re: OpenFTS as searching on partial words (response to 1)
Posted by Neophytos Demetriou on 06/10/03 12:02 PM
Yeap, that's what I meant. I was in rush while writing the message above.
Collapse
5: Re: OpenFTS as searching on partial words (response to 1)
Posted by Neophytos Demetriou on 06/10/03 01:56 PM
Ouch, reading this thread again. No, it seems that partial words searching works only in the traditional way, i.e. select * from yourtablename where title ~* 'play';

Lars, you may want to checkout http://openfts.sourceforge.net/tsearch/README.tsearch
for all features supported by tsearch (and thus openfts).

Collapse
6: Re: OpenFTS as searching on partial words (response to 1)
Posted by Roger Williams on 08/15/03 08:50 PM
Does OpenFTS handle stemming (i.e. run==runs==running==...)?

It is interesting (I found out recently) google does not!

TIA.

Regards..

Collapse
7: Re: OpenFTS as searching on partial words (response to 1)
Posted by Roger Williams on 08/15/03 09:06 PM
Also, is file-storage indexed by openFTS?

TIA.

Regards..

Collapse
8: Re: OpenFTS as searching on partial words (response to 7)
Posted by James Bennin on 08/20/03 04:06 PM
Also, is file mangager indexed by openFTS. And also which other packages are indexed by openFTS?

I am using OpenACS 4.6.3, on Red hat Linux., with PostgreSQL 7.2.

Thank you

Collapse
9: Re: OpenFTS as searching on partial words (response to 5)
Posted by James Bennin on 08/20/03 07:29 PM
It seems like you are the person whom I need to talk to since you have been involved with the search package development.  I am having some problems with the search package.  I am pretty sure I have installed OpenFTS and Search correctly.  Now I want to be able to search, or do a wide search on my site.  The major question I have is do I make an object searchable?  I have read a few series of documentations but they did not provide me with too much help.  I'd rather have a step-by-step process (similar to the OpenACS setup) to guide me through setting my objects and making them searchable.

Thank YOu