Problem with tsearch and stopwords

Поиск
Список
Период
Сортировка
От Joerg Erdmenger
Тема Problem with tsearch and stopwords
Дата
Msg-id 200308280926.41997.joe@woerd.com
обсуждение исходный текст
Ответы Re: Problem with tsearch and stopwords  (Oleg Bartunov <oleg@sai.msu.su>)
Список pgsql-general
Hi there,

I have an issue with tsearch. I'm using tsearch as a search mechanism on a
website making various queries created from the words that a user has put in.
So I query for all the words put in combined with a logical 'and' and also a
query with all the words combined with a logical 'or'. In the 'and' case
stopwords are correctly ignored whereas in the 'or' case they are not
apparently, e.g.

select 'tax&and&work'::mquery_txt;
   mquery_txt
----------------
 'tax' & 'work'
(1 row)

select 'tax|and|work'::mquery_txt;
NOTICE:  Query contains only stopword(s) or doesn't contain lexem(s), ignored
 mquery_txt
------------

(1 row)

Am I missing something? Is the only workaround to filter the stopwords myself
before I pass the query to tsearch?

Thanks

Joerg


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

Предыдущее
От: Alex
Дата:
Сообщение: Re: Question Join/Subselect
Следующее
От: "Keow Yeong Huat Joseph"
Дата:
Сообщение: Re: Postgresql for Solaris on Sparc