On Oct25, 2011, at 17:26 , Sushant Sinha wrote: > I am currently using the prefix search feature in text search. I find > that the prefix characters are treated the same as a normal lexeme and > passed through stemming and stopword dictionaries. This seems like a bug > to me.
Hm, I don't think so. If they don't pass through stopword dictionaries, then queries containing stopwords will fail to find any rows - which is probably not what one would expect. Here's an example: Query for records containing the* and car*. The @@-operator returns true, because the stopword is removed from both the tsvector and the tsquery (the 'english' dictionary drops 'these' as a stopward and stems 'cars' to 'car. Both the tsvector and the query end up being just 'car') postgres=# select to_tsvector('english', 'these cars') @@ to_tsquery('english', 'the:* & car:*'); ?column? ---------- t (1 row) Here what happens stopwords aren't removed from the query (Now, the tsvector ends up being 'car', but the query is 'the:* & car:*') postgres=# select to_tsvector('english', 'these cars') @@ to_tsquery('simple', 'the:* & car:*'); ?column? ---------- f (1 row) best regards, Florian Pflug -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers