[tsvector] to_tsvector called multiple times - Mailing list pgsql-general

From Sven R. Kunze
Subject [tsvector] to_tsvector called multiple times
Date
Msg-id 55642C5B.60809@tbz-pariv.de
Whole thread Raw
Responses Re: [tsvector] to_tsvector called multiple times
Re: [tsvector] to_tsvector called multiple times
List pgsql-general
Hi everybody,

the following stemming results made me curious:

select to_tsvector('german', 'systeme'); > 'system':1
select to_tsvector('german', 'systemes'); > 'system':1
select to_tsvector('german', 'systems'); > 'system':1
select to_tsvector('german', 'systemen'); > 'system':1
select to_tsvector('german', 'system'); >  'syst':1


First of all, this seems to be a bug in the German stemmer. Where can I
fix it?

Second, and more importantly, as I understand it, the stemmed version of
a word should be considered normalized. That is, all other versions of
that stem should be mapped to it as well. The interesting problem here
is that PostgreSQL maps the stem itself ('system') to a completely
different stem ('syst').

Should a stem not remain stable even when to_tsvector is called on it
multiple times?

--
Sven R. Kunze
TBZ-PARIV GmbH, Bernsdorfer Str. 210-212, 09126 Chemnitz
Tel: +49 (0)371 33714721, Fax: +49 (0)371 5347920
e-mail: srkunze@tbz-pariv.de
web: www.tbz-pariv.de

Geschäftsführer: Dr. Reiner Wohlgemuth
Sitz der Gesellschaft: Chemnitz
Registergericht: Chemnitz HRB 8543



pgsql-general by date:

Previous
From: Piotr Gasidło
Date:
Subject: Re: Replacing uuid-ossp with uuid-freebsd
Next
From: Albe Laurenz
Date:
Subject: Re: [tsvector] to_tsvector called multiple times