| 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: | Whole Thread | Raw Message | 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
| 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 |