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:

Hi!

I'm using postgres 8.4.3 and try to get stemming/ wrong word correction working.

I already installed the myspell dictionaries using apt-get and created postgres dictionaries like this:

Fulltext search configuration ?public.english_ispell?
Parser: ?pg_catalog.default?
    Token      |            Dictionaries
-----------------+------------------------------------
asciihword      | english_ispell,english_stem,simple
asciiword       | english_ispell,english_stem,simple
email           | simple
file            | simple
float           | simple
host            | simple
hword           | english_ispell,english_stem,simple
hword_asciipart | english_ispell,english_stem,simple
hword_numpart   | simple
hword_part      | english_ispell,english_stem,simple
int             | simple
numhword        | simple
numword         | simple
sfloat          | simple
uint            | simple
url             | simple
url_path        | simple
version         | simple
word            | english_ispell,english_stem,simple

But when I do, for example, SELECT to_tsvector('english_ispell', 'gitar') the result is only:
'gitar':1

Shouldn't the word be corrected to 'guitar'?

english_ispell dictionary is a morphology kind of dictionary ! Read docs.
Also, simple dictionary will never invoked, since english_stem dictionary
recognizes everything !



SELECT plainto_tsquery('english_ispell','gitar') doesn't work neither:
'gitar'

Better, use ts_debug() function or ts_dict() for testing.


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