Re: [GENERAL] [to_tsvector] German Compound Words

2015-06-01 Thread Sven R. Kunze
Alright. I got it running and used http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ ; specifically: http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/ispell/ispell-german-compound.tar.gz Not sure where to find up-to-date/authorized the ispell dictionaries. I figured that I ne

Re: [GENERAL] [to_tsvector] German Compound Words

2015-06-01 Thread Sven R. Kunze
I actually wanted to minimize the installation effort. Thus, I used the hunspell-de-de package of Debian/Ubuntu. Give me a second for ispell. Below, see the hunspell variant for Produktionsintervall/Produktionintervall: =# select * from ts_debug('public.german_compound', 'Produktionsinterval

Re: [GENERAL] [to_tsvector] German Compound Words

2015-05-28 Thread Sven R. Kunze
Sure. Here you are: =# select ts_debug('public.german_compound', 'wasserkraft'); ts_debug - (asciiword,"Word, all ASCII",wasserkraft,"{german_hunspell,german_stem}",german_stem,{wasserkraft}) =

Re: [GENERAL] [to_tsvector] German Compound Words

2015-05-28 Thread Oleg Bartunov
ts_debug() ? =# select * from ts_debug('english', 'messages'); alias | description | token | dictionaries | dictionary | lexemes ---+-+--++--+-- asciiword | Word, all ASCII | messages | {english_stem} | english_st

[GENERAL] [to_tsvector] German Compound Words

2015-05-28 Thread Sven R. Kunze
Hi everybody, what do I need to do in order to enable compound word handling in PostgreSQL tsvector implementation? I run an Ubuntu 14.04 machine, PostgreSQL 9.3, have installed package hunspell-de-de and already created a new dictionary as described here: http://www.postgresql.org/docs/9.3/