Full Text Search - Influenceing the creation of tsvector

Поиск
Список
Период
Сортировка
От Pauline Dubois
Тема Full Text Search - Influenceing the creation of tsvector
Дата
Msg-id 706473.96479.qm@web23905.mail.ird.yahoo.com
обсуждение исходный текст
Ответы Re: Full Text Search - Influenceing the creation of tsvector  (ANdreas Wenk <a.wenk@netzmeister-st-pauli.de>)
Список pgsql-novice
Дерево обсуждения
Dear all,

like described in the docs i have created a separate tsvector column to hold the output of to_tsvector.
UPDATE foo_table SET textsearchable_index_col =
     to_tsvector('english', coalesce(name,'')
The problem is that i have names like  'foo-bar'.
The char '-' is a space symbol.
The tsvector lokks like:
"'bar':3 'foo':2 'foo-bar':1"

A
"SELECT *
FROM foo_table
WHERE textsearchable_index_col @@ to_tsquery('foo')"

finds now 'foo-bar', but this is not what i want because i have 'foo-bar1,foo-bar2..'. Because of performace only 'foo-bar(n)' should match.

The docs are good but a bit intimidating and i don't understand all.

Is there a way to create the tsvector lokks like:
"''foo-bar':1" so that the space symbol would be ignored?

best regards,
pauline

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

Предыдущее
От: Mike
Дата:
Сообщение: Re: How to insert data from a text file
Следующее
От: Bruce Hyatt
Дата:
Сообщение: Re: Yum Update Errors - SOLVED -