TSearch and phrase searches
| От | Robert John Shepherd |
|---|---|
| Тема | TSearch and phrase searches |
| Дата | |
| Msg-id | 006a01c27f70$b47a64e0$f3b0313e@LAIKA обсуждение исходный текст |
| Ответы |
Re: TSearch and phrase searches
|
| Список | 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@robertsworld.org.uk
В списке pgsql-general по дате отправления: