Postgres Pro
Downloads
Home   >   mailing lists

Thread: Searching for symbols with tsearch

Searching for symbols with tsearch

From
"Christopher Kings-Lynne"
Date:
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

Re: Searching for symbols with tsearch

From
Hannu Krosing
Date:
Christopher Kings-Lynne kirjutas T, 29.04.2003 kell 09:19:
> 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.

It is probably illegal to remove the trailing TM or (C) ;)

-------------
Hannu

Re: Searching for symbols with tsearch

From
"scott.marlowe"
Date:
On 29 Apr 2003, Hannu Krosing wrote:

> Christopher Kings-Lynne kirjutas T, 29.04.2003 kell 09:19:
> > 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.
> 
> It is probably illegal to remove the trailing TM or (C) ;)

Yeah, it's probably all the new DRM code in the linux kernel doing that. 
;^)

Re: Searching for symbols with tsearch

From
Teodor Sigaev
Date:
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@postgresql.org)

-- 
Teodor Sigaev                                  E-mail: teodor@sigaev.ru