maximum distance vs fixed distance for tsquery_phrase

2019-07-18 Thread Where is Where
Hello the tsquery_phrase is searching a fixed distance, is there way to search maximum distance so the search returns query1 followed by query2 up to a certain distance? eg distance=100 return result from query1 <1> query2 ... query1 <100> query2 ? Thanks! tsquery_phrase(query1 tsquery, query2 ts

Re: tsvector 256 limit and matching text with common words

2018-11-28 Thread Where is Where
> Hello, I am wondering if it is possible to increase or remove the > '256 positions per lexeme' limit? > > We need to search words with common words like 'the' 'a' in full text. Or > is there workaround for it? Thanks! > ps: this has not been posted on other list.