Hello,
Your problem is not about stop words, it's about the fact that tsearch
parser treats '+' and '#' symbols as a lexemes of a blank type (use
ts_debug() function to figure it out) and drops it without any further
processing. AFAIK, typical solution for this is to rewrite your text
and then qu
postgres=# select to_tsvector('default','I know how to code in C#, java and
C++');
to_tsvector
-
'c':7,10 'code':5 'java':8 'know':2
(1 row)
postgres=# select to_tsvector('simple','I know how to code in C#, java and
C++');