Full Text Search - Influenceing the creation of tsvector

Поиск

Список

Период

Сортировка

От	Pauline Dubois
Тема	Full Text Search - Influenceing the creation of tsvector
Дата	19 июня 2009 г. 06:24:37
Msg-id	706473.96479.qm@web23905.mail.ird.yahoo.com обсуждение
Ответы	Re: Full Text Search - Influenceing the creation of tsvector
Список	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 по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Full Text Search - Influenceing the creation of tsvector