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 previous versions of Postgres though. See http://www.sai.msu.su/~megera/oddmuse/index.cgi/ReadmeTrgm -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) Hi! I'm a .signature virus! cp me into your .signature file to help me spread! ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
