| From: | "Robert John Shepherd" <robert(at)reviewer(dot)co(dot)uk> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | TSearch and phrase searches |
| Date: | 2002-10-29 17:28:49 |
| Message-ID: | 006a01c27f70$b47a64e0$f3b0313e@LAIKA |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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!
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(at)robertsworld(dot)org(dot)uk
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Old | 2002-10-29 17:53:09 | Stream data into Postgres via Perl |
| Previous Message | Afra | 2002-10-29 17:26:48 | EXPLAIN times |