469,273 Members | 1,827 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,273 developers. It's quick & easy.

Problem with tsearch and stopwords

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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 11 '05 #1
0 1207

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Joerg Erdmenger | last post: by
13 posts views Thread by Nigel J. Andrews | last post: by
1 post views Thread by sector119 | last post: by
4 posts views Thread by Bas Scheffers | last post: by
2 posts views Thread by Fischer Ulrich | last post: by
2 posts views Thread by Rajesh Kumar Mallah | last post: by
1 post views Thread by linbl352 | last post: by
reply views Thread by almurph | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.