Rick Schumeyer <rschumeyer@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general