Re: Text search name and name synonims dictionary

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