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 2C7C2D1B266
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 12 Jul 2004 11:06:11 -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 51198-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 12 Jul 2004 14:06:13 +0000 (GMT)
Received: from trade-india.com (unknown [61.16.154.82])
	by svr1.postgresql.org (Postfix) with SMTP id 7BFE4D1B252
	for <pgsql-sql@postgresql.org>; Mon, 12 Jul 2004 11:05:59 -0300 (ADT)
Received: (qmail 311 invoked from network); 12 Jul 2004 14:04:41 -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 14:04:41 -0000
Message-ID: <40F29ACB.5090200@trade-india.com>
Date: Mon, 12 Jul 2004 19:36:03 +0530
From: Rajesh Kumar Mallah <mallah@trade-india.com>
User-Agent: Mozilla Thunderbird 0.6 (X11/20040502)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Achilleus Mantzios <achill@matrix.gatewaynet.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Comparing tsearch2 vectors.
References: <Pine.LNX.4.44.0407121454040.3671-100000@matrix.gatewaynet.com>
In-Reply-To: <Pine.LNX.4.44.0407121454040.3671-100000@matrix.gatewaynet.com>
Content-Type: text/plain; charset=us-ascii; 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/70
X-Sequence-Number: 18322

Achilleus Mantzios wrote:

>O kyrios Rajesh Kumar Mallah egrapse stis Jul 12, 2004 :
>
>  
>
>>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).
>>    
>>
>
>You could transform your search terms so that there is the "&"
>separator between them. (& stands for "AND").
>E.g. "handicrafts exporter" becomes "handicrafts&exporter"
>And then
>select * from <your table> where idxfti @@ to_tsquery(<searchterms>);
>  
>

But i do not want 'handicraft exporters of delhi' to pop out if i search
for 'handicrafts exporters' whereas

SELECT to_tsvector('handycrafts exporters of delhi') @@ to_tsquery('handycraft&exporting');

will be true.

Regds
Mallah.



>where idxfti is your tsvector column.
>
>E.g.
># SELECT to_tsvector('handycrafts exporters') @@ to_tsquery('handycraft&exporting');
> ?column?
>----------
> t
>(1 row)
> 
>
>
>  
>
>>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/			    |
+---------------------------------------------------+