Return-Path: <wakathane@gmail.com>
Received: from [192.168.1.20] (HSI-KBW-082-212-034-242.hsi.kabelbw.de
	[82.212.34.242])
	by mx.google.com with ESMTPS id 15sm248886bwz.4.2010.04.08.13.54.38
	(version=SSLv3 cipher=RC4-MD5); Thu, 08 Apr 2010 13:54:39 -0700 (PDT)
Message-ID: <4BBE428E.6090607@gmail.com>
Date: Thu, 08 Apr 2010 22:54:38 +0200
From: Corin <wakathane@gmail.com>
User-Agent: Thunderbird 2.0.0.24 (X11/20100317)
MIME-Version: 1.0
To: Oleg Bartunov <oleg@sai.msu.su>, pgsql-general@postgresql.org
Subject: Re: [GENERAL] fulltext search stemming/ spelling problems
References: <4BBDF08C.9080103@gmail.com>
	<Pine.LNX.4.64.1004082213130.8023@sn.sai.msu.ru>
	<4BBE2BF3.3070409@gmail.com>
	<Pine.LNX.4.64.1004082325310.8023@sn.sai.msu.ru>
In-Reply-To: <Pine.LNX.4.64.1004082325310.8023@sn.sai.msu.ru>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 08.04.2010 21:27, Oleg Bartunov wrote:
> 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.
I already read this but I don't know how to solve my problems with this 
information.

SELECT ts_lexize('english_ispell','guitar');
{guitar}
(1 line)

SELECT ts_lexize('english_ispell','bank');
{bank}
(1 line)

SELECT ts_debug('english_ispell','bank');
(asciiword,"Word, all 
ASCII",bank,"{english_ispell,english_stem}",english_ispell,{bank})
(1 line)

SELECT plainto_tsquery('english_ispell','bank');
'bank'
(1 line)
>     Regards,
>         Oleg
It would be very nice if you (or anyone else) could provide me with 
concrete instructions or any howto. What can I do to find the error in 
my setup? What output should I expect from the above comments if 
everything worked correctly?

Thanks,
Corin