X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6EDEFD1B18E for ; Mon, 12 Jul 2004 09:34:28 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 08417-07 for ; Mon, 12 Jul 2004 12:34:32 +0000 (GMT) Received: from trade-india.com (unknown [61.16.154.82]) by svr1.postgresql.org (Postfix) with SMTP id 8F113D1B181 for ; Mon, 12 Jul 2004 09:34:20 -0300 (ADT) Received: (qmail 29824 invoked from network); 12 Jul 2004 12:33:03 -0000 Received: from valium.trade-india-local.com (HELO ?192.168.0.100?) (192.168.0.100) by system66.trade-india-local.com with SMTP; 12 Jul 2004 12:33:03 -0000 Message-ID: <40F28551.3030605@trade-india.com> Date: Mon, 12 Jul 2004 18:04:25 +0530 From: Rajesh Kumar Mallah User-Agent: Mozilla Thunderbird 0.6 (X11/20040502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Achilleus Mantzios Cc: pgsql-sql@postgresql.org Subject: Re: Comparing tsearch2 vectors. References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/66 X-Sequence-Number: 18318 Dear Mantzios, I have to get set of banners from database in response to a search term. I want that the search term be compared to the keyword corresponding to the banners stored in database. current i am doing an equality match but i woild like to do it after stemming both the sides (serch term and keywords). So that the banners for the adword say 'incense exporter' is shown even if 'incenses exporter' or 'incense exporters' is searched. I hope i am able to clarify. Regds Mallah. Achilleus Mantzios wrote: >O kyrios Rajesh Kumar Mallah egrapse stis Jul 12, 2004 : > > > >>Hi, >> >>We want to compare strings after stemming. Can anyone >>tell me what is the best method. I was thinking to compare >>the tsvector ,but there is no operator for that. >> >> > >I'd tokenize each string and then apply lexize() to get the >equivalent stemified >word, but what exactly are you trying to accomplish? > > > >>Regds >>Mallah. >> >> >> >>tradein_clients=# SELECT to_tsvector('handicraft exporters'); >>+---------------------------+ >>| to_tsvector | >>+---------------------------+ >>| 'export':2 'handicraft':1 | >>+---------------------------+ >>(1 row) >> >>Time: 710.315 ms >>tradein_clients=# >>tradein_clients=# SELECT to_tsvector('handicrafts exporter'); >>+---------------------------+ >>| to_tsvector | >>+---------------------------+ >>| 'export':2 'handicraft':1 | >>+---------------------------+ >>(1 row) >> >>Time: 400.679 ms >>tradein_clients=# SELECT to_tsvector('Hi there') = to_tsvector('Hi there'); >>ERROR: operator does not exist: tsvector = tsvector >>HINT: No operator matches the given name and argument type(s). You may >>need to add explicit type casts. >>tradein_clients=# >> >> >> >> > > > -- regds Mallah. Rajesh Kumar Mallah +---------------------------------------------------+ | Tradeindia.com (3,11,246) Registered Users | | Indias' Leading B2B eMarketPlace | | http://www.tradeindia.com/ | +---------------------------------------------------+