Re: Searching for symbols with tsearch

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>, oleg(at)sai(dot)msu(dot)su
Subject: Re: Searching for symbols with tsearch
Date: 2003-04-29 15:41:12
Message-ID: 3EAE9D18.7030700@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Add to dictionary code which remove (TM), (C) or (R) sign at the end of lexeme
and then do usial processing.

Christopher Kings-Lynne wrote:
> Hi Guys,
>
> I'm working with tsearch, but there's a problem with words with trailing TM
> symbol or (C) symbol. Tsearch will not stem these words, hence they are
> unsearchable.
>
> Eg:
>
> 6 Under 6 Salads (no dressing): Veggie DeliteT
>
> Is indexed as:
>
> '6' 'dress' 'salad' 'veggi' 'deliteT'
>
> Where it really should be indexed as:
>
> '6' 'dress' 'salad' 'veggi' 'delit'
>
> Anything I can do about this?
>
> Chris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Sailesh Krishnamurthy 2003-04-29 16:10:23 Re:
Previous Message Tom Lane 2003-04-29 15:30:13 Re: Problem with COPY on RedHat 8 with PostgreSQL 7.3.2