maximum distance vs fixed distance for tsquery_phrase

From: Where is Where <whisere(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: maximum distance vs fixed distance for tsquery_phrase
Date: 2019-07-19 03:55:46
Message-ID: CAK3r-hNrVyceCUH=W=RN7N8S2pQGZGet4ctd8WHrG0KsMKo_HQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 tsquery, distance integer)

Browse pgsql-general by date

  From Date Subject
Next Message Luca Ferrari 2019-07-19 08:21:05 Re: Rearchitecting for storage
Previous Message Andy Colson 2019-07-19 01:59:01 Re: Rearchitecting for storage