Full text search strategy for names

Поиск
Список
Период
Сортировка
От Rick Schumeyer
Тема Full text search strategy for names
Дата
Msg-id 95b1cc100904161843o13abe5a8kd595e1a97316f75b@mail.gmail.com
обсуждение исходный текст
Ответы Re: Full text search strategy for names  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
Re: Full text search strategy for names  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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?

В списке pgsql-general по дате отправления:

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: Looking for advice on database encryption
Следующее
От: Irwan Hendra
Дата:
Сообщение: postgres cascade weird behaviour