Rick Schumeyer <rschumeyer@gmail.com> writes:
> I want to be able to search a list of articles for title words as well as
> author names. I understand how to do the title words with the full text
> searching. But I'm not sure the best strategy for the names. The full text
> parser "parses" the names giving undesirable results.
> For example,
> select to_tsvector('claude Jones');
> to_tsvector
> --------------------
> 'jone':2 'claud':1
Er ... why is that a problem? As long as the index stems the words in
the same way that the query does, why should you care?
regards, tom lane