Re: [PATCH] Phrase search ported to 9.6 - Mailing list pgsql-hackers

From Andreas Joseph Krogh
Subject Re: [PATCH] Phrase search ported to 9.6
Date
Msg-id VisenaEmail.8.c7513bdf4b62d6b.153d20ee695@tc7-visena
Whole thread Raw
In response to Re: [PATCH] Phrase search ported to 9.6  (Teodor Sigaev <teodor@sigaev.ru>)
List pgsql-hackers
På fredag 01. april 2016 kl. 15:22:55, skrev Teodor Sigaev <teodor@sigaev.ru>:
> there was a character that was very similar to dots I would suggest
> that.  The closest is * I think, so what do you think of "***"?

And join opertator for tsqueries is the same :
select 'fat'::tsquery *** 'cat'; ?

Single '*' ?  That's close to regex, any number of tokens. And it saves rules
about duplicating character.

select 'fat'::tsquery ** 'cat';
select 'fat * cat'::tsquery;
select 'fat * [3] cat'::tsqyery; -- for non-default distance.
 
What about ~> ?
 
--
Andreas Joseph Krogh

pgsql-hackers by date:

Previous
From: "Shulgin, Oleksandr"
Date:
Subject: Re: SSL indicator in psql prompt
Next
From: Aleksander Alekseev
Date:
Subject: Re: WIP: Access method extendability