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