Re: TSearch: Need debug help

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Subject: Re: TSearch: Need debug help
Date: 2006-08-03 11:15:51
Message-ID: 44D1DAE7.2070301@theendofthetunnel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> but does 'dursten' is a some form of 'durst' ?

Yes it is.

Hm, even when I remove `dursten' and `durst' all together from the dict
I still get `sen'.

How can I update a tsvector column stripping the `sen' lexem?

Thanks!

On 03.08.2006 12:54, Oleg Bartunov wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

--
Regards,
Hannes Dorbath

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kenneth Downs 2006-08-03 11:33:39 Re: Best Procedural Language?
Previous Message Oleg Bartunov 2006-08-03 10:54:05 Re: TSearch: Need debug help