How do the search with fulltext considering the minus and underscore with postgres?
When I try to look for a plant that contains the minus it does not return a result even escaping the minus sign, but this behavior happens only when the minus sign is followed by some number.
my query: SELECT cmis:name, dc:title FROM arizona:file WHERE CONTAINS(' “rafa 123” ')
my query: SELECT cmis:name, dc:title FROM arizona:file WHERE CONTAINS(' “rafa\\-123” ')
my query: SELECT cmis:name, dc:title FROM arizona:file WHERE CONTAINS(' “rafa-123” ') It seems that he considers the minus sign before a number as an arithmetic operation …
Is there some setting I can do to change this behavior?
If I change the algorithm to consider the minus and underscore to be identified as caracters this behavior change? 2.1 If this is the solution how can I proceed?