FTS and words near one another

Started by Arturo Perezabout 15 years ago2 messagesgeneral
Jump to latest
#1Arturo Perez
arturo@pleeque.com

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

#2Dimitri Fontaine
dimitri@2ndQuadrant.fr
In reply to: Arturo Perez (#1)
Re: FTS and words near one another

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