tsearch can help you; i have a system with it ... and its ok.
El mar, 05-08-2008 a las 18:03 +0400, Vyacheslav Kalinin escribió:
> 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?
>
>
>