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++'); to_tsvector ------------------------------------------------------------------------- 'c':7,10 'i':1 'in':6 'to':4 'and':9 'how':3 'code':5 'java':8 'know':2 (1 row)
I'd like to get lexemes/tokens 'c#' and 'c++' out of this query. Everything I can find has to do with stop words. How do I keep characters that tsearch throws out? I've already tried 'c\#' and 'c\\#' etc, which don't work.