How do the search with fulltext considering the minus and underscore with postgres?

[Thiago_Valentim]

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 ...

1. Is there some setting I can do to change this behavior?

2. 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?

[Florent_Guillau]

Could you replace the screenshots with text please? It makes for an easier-to-read question, and allows for searchability.

[Thiago_Valentim]

I edited the post, added the query near the screenshots