Re: knngist - 0.8 - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Re: knngist - 0.8
Date
Msg-id AANLkTinV_HK3CLC6_98coYkorPC75vsdYO7vheTmv5Yd@mail.gmail.com
Whole thread Raw
In response to knngist - 0.8  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: knngist - 0.8
List pgsql-hackers
I think that queries like this:<br />select * from test where val <-> 500 < 1 order by val <-> 500;<br
/>canalso be optimized using knngist. In case of btree_gist this query can be easily rewritten:<br />select * from test
whereval > 499 and val < 501 order by val <-> 500;<br /> But, in pg_trgm it makes it possible to combine
differentsimilarity levels in one query. For example:<br />select * from test_trgm order by t <-> 'asdf' < 0.5
ort <-> 'qwer' < 0.4;<br />Is there any chance to handle this syntax also?<br /><br />----<br />With best
regards,<br/>Alexander Korotkov.<br /> 

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: review: xml_is_well_formed
Next
From: Robert Haas
Date:
Subject: Re: patch (for 9.1) string functions