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” ') alt text

my query: SELECT cmis:name, dc:title FROM arizona:file WHERE CONTAINS(' “rafa\\-123” ') alt text

my query: SELECT cmis:name, dc:title FROM arizona:file WHERE CONTAINS(' “rafa-123” ') alt text 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?

0 votes

0 answers

955 views

ANSWER

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

I edited the post, added the query near the screenshots
09/30/2013