Re: [GENERAL] any solution for full text search in Postgres for partial words

2004-08-25 Thread Alvaro Herrera
On Wed, Aug 25, 2004 at 11:14:36AM -0400, Liu, Mingyi wrote: > 1. Is there existing open-source FTI for postgres that allows partial words search? I think a trigram-based solution could help you here. In 8.0beta there is a contrib/pg_trgm module that implements such a thing. It isn't present on

[GENERAL] any solution for full text search in Postgres for partial words

2004-08-25 Thread Liu, Mingyi
Sorry if this question has been asked before. I tried to search in postgres mailing lists at http://archives.postgresql.org/pgsql-general/ just now and it gave me error "An error occured! Can not connect to search daemon". Anyway I installed tsearch2 and openFTS and was able to do some searches