Re: [SQL] Comparing tsearch2 vectors.

2004-07-13 Thread Achilleus Mantzios
O kyrios Rajesh Kumar Mallah egrapse stis Jul 13, 2004 : > Achilleus Mantzios wrote: > > >O kyrios Rajesh Kumar Mallah egrapse stis Jul 12, 2004 : > > > > > > > >>Achilleus Mantzios wrote: > >> > >> > >> > >>>O kyrios Rajesh Kumar Mallah egrapse stis Jul 12, 2004 : > >>> > >>> > >>> > >>>

Re: [SQL] Comparing tsearch2 vectors.

2004-07-12 Thread Rajesh Kumar Mallah
Achilleus Mantzios wrote: O kyrios Rajesh Kumar Mallah egrapse stis Jul 12, 2004 : 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

Re: [SQL] Comparing tsearch2 vectors.

2004-07-12 Thread Achilleus Mantzios
O kyrios Rajesh Kumar Mallah egrapse stis Jul 12, 2004 : > 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 >

Re: [SQL] Comparing tsearch2 vectors.

2004-07-12 Thread Rajesh Kumar Mallah
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 a

Re: [SQL] Comparing tsearch2 vectors.

2004-07-12 Thread Achilleus Mantzios
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 > equal

Re: [SQL] Comparing tsearch2 vectors.

2004-07-12 Thread Rajesh Kumar Mallah
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

Re: [SQL] Comparing tsearch2 vectors.

2004-07-12 Thread Achilleus Mantzios
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

[SQL] Comparing tsearch2 vectors.

2004-07-12 Thread Rajesh Kumar Mallah
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. Regds Mallah. tradein_clients=# SELECT to_tsvector('handicraft exporters'); +---+ |to_tsvector