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

From Tom Lane
Subject Re: [PATCH] Phrase search ported to 9.6
Date
Msg-id 11634.1459520653@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCH] Phrase search ported to 9.6  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: [PATCH] Phrase search ported to 9.6  (Oleg Bartunov <obartunov@gmail.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> Teodor Sigaev wrote:
>> may be <=>? it isn't used anywhere yet.
>> 
>> select 'fat'::tsquery <=> 'cat';
>> select 'fat <=> cat'::tsquery;
>> select 'fat <3> cat'::tsqyery; -- for non-default distance.

> Dunno.  That looks pretty "relationalish".

The existing precedent in the geometric types is to use <->
as an operator denoting distance.  Perhaps <-> amd <3>
would work here.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: SSL indicator in psql prompt
Next
From: Kevin Grittner
Date:
Subject: Re: snapshot too old, configured by time