X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 182F59DC813 for ; Mon, 23 Jan 2006 12:51:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 86227-02 for ; Mon, 23 Jan 2006 12:51:28 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ra.sai.msu.su (ra.sai.msu.su [158.250.29.2]) by postgresql.org (Postfix) with ESMTP id 4ECA99DC804 for ; Mon, 23 Jan 2006 12:51:16 -0400 (AST) Received: from ra (ra [158.250.29.2]) by ra.sai.msu.su (8.13.4/8.13.4) with ESMTP id k0NGnu1r009019; Mon, 23 Jan 2006 19:49:57 +0300 (MSK) Date: Mon, 23 Jan 2006 19:49:56 +0300 (MSK) From: Oleg Bartunov X-X-Sender: megera@ra.sai.msu.su To: Michael Fuhr cc: "Praveen Kumar (TUV)" , brad@kieser.net, pgsql-admin@postgresql.org Subject: Re: Full Text Indexing Using Tsearch2-Module In-Reply-To: <20060123164421.GA28344@winnie.fuhr.org> Message-ID: References: <84D57263D486374587DA0820E60A2CC60724E1@srit_mail.renaissance-it.com> <20060123164421.GA28344@winnie.fuhr.org> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.394 required=5 tests=[AWL=-0.085, DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.394 X-Spam-Level: X-Archive-Number: 200601/270 X-Sequence-Number: 20358 The simplest way is to use custom dictionary like 'synonym' ! many:many and let it first dictionary ! Oleg On Mon, 23 Jan 2006, Michael Fuhr wrote: > On Mon, Jan 23, 2006 at 03:05:07PM +0530, Praveen Kumar (TUV) wrote: >> 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. > > Your tsearch2 configuration is turning the words "many" and "andy" > into the lexemes "mani" and "andi", like this: > > test=> SELECT * FROM ts_debug('many andy'); > ts_name | tok_type | description | token | dict_name | tsvector > ---------+----------+-------------+-------+-----------+---------- > default | lword | Latin word | many | {en_stem} | 'mani' > default | lword | Latin word | andy | {en_stem} | 'andi' > (2 rows) > > To learn how to change that see "Parsing and Lexing" and "Configurations" > in the tsearch2 documentation: > > http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch2-guide.html#parsing_lexing > http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch2-ref.html#configurations > > Another approach is to think of tsearch2 as returning "might match" > rows and add another restriction to find the definite matches: > > test=> SELECT * FROM foo > test-> WHERE idxcontent @@ to_tsquery('many'); > id | content | idxcontent > ----+---------+------------ > 1 | many | 'mani':1 > 2 | mani | 'mani':1 > (2 rows) > > test=> SELECT * FROM foo > test-> WHERE idxcontent @@ to_tsquery('many') AND content ~* 'many'; > id | content | idxcontent > ----+---------+------------ > 1 | many | 'mani':1 > (1 row) > > Regards, Oleg _____________________________________________________________ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83