PostgreSQL Administration - Full Text Indexing Using Tsearch2-Module

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Full Text Indexing Using Tsearch2-Module

Praveen Kumar

2006-01-30, 3:23 am

Hello All,
I have installed Tsearch-Module for full text indexing .But when I search text using gist(idxFTI) index on table I also found
all data which have same accent.Example
1.If I try search for MANI word it also search for MANY word.
2.If I try search for ANDY word it also search for ANDI word.
Please can you tell me how to avoid this problem ? If i want to search text MANI it should search only for MANI not MANY.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Sponsored Links