Forum OpenACS Q&A: Response to Full text search in PostgreSQL?

Collapse
Posted by Don Baccus on
Yes and no.  The full text searching module you're referring to is extremely limited so not directly useful to us.  The basic notion - build an index table to search - is the way one would have to do it, so the code might be poachable and serve as the basis of some more flexible and useful.  The guy who did it needed to find proper names, so does no stemming of words, doesn't attempt to deal with phrases, doesn't do any weighted matching, etc.  He did a great job of writing something to meet his personal needs, but no more.  That's probably why it's in contrib rather than mainstreamed.

I'm personally interested in doing a full text searching enhancement in the future.  Perhaps in summer?  It will depend on many things, i.e. contract work I might take on, the work I need to do on my own personal site, and how much Postgres internals work I decide to tackle  for 7.1 (I'm currently signed up for a small piece but may offer more  time).