TSearch and phrase searches

On Tue, 29 Oct 2002, Robert John Shepherd wrote:

After exploring various options for full text indexing, I've settled on
using tsearch, since it appears to offer the most flexible options (and
is easy enough to use on an imported database not created from scratch),
but...

I can't seem to work out how to search for phrases with it. Is this
possible? Or do I have to use a nested SELECT query to pull out all the
entries containing the words in a phrase, and then search those again
using a LIKE query?

OpenFTS seems to perform phrase searches, and that uses tsearch, so it
must be possible!

OpenFTS uses additional tables with coordinate information, that's why
it could range results based on proximity between query words.
There were many requests to add ranking feature to tsearch but we are very
busy this year.

Ta for any help.

Yours Unwhettedly,
Robert John Shepherd.

Editor
DVD REVIEWER
The UK's BIGGEST Online DVD Magazine
http://www.dvd.reviewer.co.uk

For a copy of my Public PGP key, email: pgp@robertsworld.org.uk

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83