topic Re: How do the search with fulltext considering the minus and underscore with postgres? in Nuxeo Forum

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

Thiago_Valentim — Mon, 30 Sep 2013 16:23:44 GMT

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?

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

Florent_Guillau — Mon, 30 Sep 2013 16:46:42 GMT

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

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

Thiago_Valentim — Mon, 30 Sep 2013 18:32:27 GMT

I edited the post, added the query near the screenshots