Re: Full text search strategy for names

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