| From: | "Vyacheslav Kalinin" <vka(at)mgcp(dot)com> |
|---|---|
| To: | PGSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | FTS on patterns |
| Date: | 2008-08-05 14:03:15 |
| Message-ID: | 9b1af80e0808050703y4b40b4cgef17ceb313bd6fa8@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
In our application we need a pattern based text search, that is if user
supplies 'foo bar' he receives only documents containing words that begin
with 'foo' or 'bar', including themselves (something similar to MySQL '+foo*
+bar*' text search query). Currently we use separate table for unique words
in document and do LIKE 'foo%' search on that table, combining the results
afterwards, and I am not really happy with that solution because of its
speed and overcomplication of the queries involved. Does anyone know of a
better approach? Could this be achieved with Postgres full text search?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Felipe de Jesús Molina Bravo | 2008-08-05 14:23:28 | Re: FTS on patterns |
| Previous Message | Tom Lane | 2008-08-05 13:45:23 | Re: Initdb problem on debian mips cobalt: Bus error |