Thread: FTS and words near one another

FTS and words near one another

From
Arturo Perez
Date:
Hi all,

Is there currently anyway in 9.0 to use FTS to search for words that are
next to each other?

For example, I want to search for Abraham next to Lincoln and ignore
things like 'Abraham Johnson who lives in Lincoln Nebraska'.

tia,
arturo

Re: FTS and words near one another

From
Dimitri Fontaine
Date:
Arturo Perez <arturo@pleeque.com> writes:
> Is there currently anyway in 9.0 to use FTS to search for words that are
> next to each other?

Oleg and Teodor worked on that at some point and they call it phrase
search.  I don't think it's been commited yet, you can see reference
material in their presentation at pgcon here:

  http://www.pgcon.org/2009/schedule/events/119.en.html

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support