Oleg Bartunov wrote:
> On Thu, 29 Jan 2009, Igor Katson wrote:
>
>> I have a column, containing the name of the user and there is a need
>> to organize an indexed search on this column. As far as I understand,
>> I need to use the full-text search capabilities of postgres.
>>
>> I would like to attach a dictionary, containing many possible names,
>> and the short names like:
>>
>> William Will Bill Billy
>> James Jim Jimmy
>>
>> etc., which will give me a possibility to perform indexed search on
>> any of these names and it will give me all the matches on variations
>> of the name, regardless of which of them was chosen as a search
>> argument.
>>
>> 1. Is it possible to do that with postgres' full-text search
>> capabilities?
>
> yes, look on contrib/dict_xsyn
>
>> 2. Does anyone know, if there is a Russian dictionary of these names?
>
> there are printed dictionaries, not sure about electronic versions.
>
>
>> 3. What is the name of such kind of dictionary, to know, what to
>> google for?
>
> http://yandex.ru/yandsearch?text=словарь+личных+имен
>
>>
>> Thanks in advance, and regards
>> Igor Katson.
>>
>>
>
> Regards,
> Oleg
> _____________________________________________________________
>
Thanks for the help, Oleg!