Re: [GENERAL] tsearch2 keep throw-away characters

2007-05-19 Thread Ivan Zolotukhin
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

[GENERAL] tsearch2 keep throw-away characters

2007-05-19 Thread Kimball
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++');