Re: TSearch: Need debug help

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: TSearch: Need debug help
Date: 2006-08-03 10:54:05
Message-ID: Pine.GSO.4.63.0608031450210.9291@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hannes,

I don't know german, sorry, but does 'dursten' is a some form of 'durst' ?
Probably, here we have false hit from compound word support. I'd suggest
to use exclusion dictionary (on the base of synonym dictionary)
before ispell. It could be very simple:
durst : durst

Oleg

On Thu, 3 Aug 2006, Hannes Dorbath wrote:

> SELECT ts_debug('durst');
> (default_german,lword,"Latin word",durst,"{de_ispell,de}","'dur' 'sen'")
>
> SELECT ts_debug('h?chsten');
> (default_german,word,Word,h?chsten,"{de_ispell,de}","'sen' 'h?ch' 'h?chst'
> 'h?chsten'")
>
> For some reason both produce the lexem 'sen'. That leads to strange results.
> Search for `durst' will highlight `h?chsten' with headline().
>
> Server is PG 8.0.4,
> german snowball stemmer,
> dictionary used is http://hannes.imos.net/german_iso.med
> (From OpenOffice)
>
> What causes some words to result in `sen', though they don't contain that
> lexem?
>
> Thanks!
>
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hannes Dorbath 2006-08-03 11:15:51 Re: TSearch: Need debug help
Previous Message Christian Rengstl 2006-08-03 10:27:36 Re: Query performance