something like this ?
http://www.sai.msu.su/~megera/wiki/2009-08-12
http://www.sai.msu.su/~megera/postgres/talks/algebra-fts.pdf
Unfortunately, we get no support for this work, so we stop maintaining
phrase-search patch. I even thinking about kikstarter.com to get money
for this project :)
Oleg
On Mon, 24 Sep 2012, W. Matthew Wilson wrote:
> I noticed in elastic search (ES), you can do queries like
>
> "a b"~4
>
> I think this query will match stuff like "a b" and "a x x b" but not
> something like "a x x x x x x x x b".
>
> I'm not sure if this kind of thing is possible with postgresql full
> text search. Is it possible?
>
> I understand that I can do a query and rank the results by how closely
> the words are to each other, but I want to exclude any matches where
> the words are not within two words of each other.
>
> Thanks in advance!
>
> Matt
>
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83