Search Postgresql Archives

Re: fulltext search stemming/ spelling problems

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, 8 Apr 2010, Corin wrote:

On 08.04.2010 20:15, Oleg Bartunov wrote:
On Thu, 8 Apr 2010, Corin wrote:

english_ispell dictionary is a morphology kind of dictionary ! Read docs.
Also, simple dictionary will never invoked, since english_stem dictionary
recognizes everything !
I'm not sure what you mean with 'morphology'. I sure read the docs but couldn't find anything about 'morphology disctionaries'.

it means, that (from http://www.postgresql.org/docs/current/static/textsearch-dictionaries.html#TEXTSEARCH-ISPELL-DICTIONARY)

12.6.5. Ispell Dictionary

The Ispell dictionary template supports morphological dictionaries, which can normalize many different linguistic forms of a word into the same lexeme. For example, an English Ispell dictionary can match all declensions and conjugations of the search term bank, e.g., banking, banked, banks, banks', and bank's.

you confused with the name !


I created it myself with the following commands, after I installed the ispell dictionaries using "apt-get":

CREATE TEXT SEARCH DICTIONARY english_ispell (
  TEMPLATE = ispell,
  DictFile = system_en_us,
  AffFile = system_en_us
);

CREATE TEXT SEARCH CONFIGURATION english_ispell ( COPY = pg_catalog.english );
ALTER TEXT SEARCH CONFIGURATION english_ispell
ALTER MAPPING FOR asciiword, asciihword, hword_asciipart, word, hword, hword_part WITH english_ispell, english_stem;

Thank's for the hint with simple dictionary. I'll remove it - but when it's never triggered, I gues it won't solve my problem neither?

Better, use ts_debug() function or ts_dict() for testing.
ts_debug shows:
SELECT ts_debug('english_ispell','gitar');
(asciiword,"Word, all ASCII",gitar,"{english_ispell,english_stem}",english_stem,{gitar})
(1 line)

ts_dict does not seem to exist, I neither couldn't find it in the docs.

sorry, ts_lexize


    Regards,
        Oleg
Thanks,
Corin


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

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux