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
|
| Список | 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 по дате отправления: