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
Is there a way to tell the parser to index the words in a column without trying to determine word roots?
Or what is the best way to index names for efficient searching?
