Full Text Search: howto manage multiple languages ?
Hi,
I have the following problem with the FTS: the database contains information
in several languages. As I understand, the FTS requires to associate a
language when ts_vector is created. Is there any way to make a kind of
international search, without having to associate a specific language to the
ts_vector ? I must admit that it's quite ambiguous, but let's imagine that
you have a worldwide address repository. In that case, you can find "Rue",
"Street", "Strasse" etc... which have all a low significancy.
Thanks in advance for any tips,
Cédric
--
Welcome to my world: http://www.cedricmoullet.com/
My Linked In profile: http://www.linkedin.com/in/cedricmoullet
Twitter: http://twitter.com/cedricmoullet
On Sun, 21 Mar 2010, C?dric MOULLET wrote:
Hi,
I have the following problem with the FTS: the database contains information
in several languages. As I understand, the FTS requires to associate a
language when ts_vector is created. Is there any way to make a kind of
FTS doesn't needs to be asscociated with specific language ! FTS requires
its configuration, which binds specific lexeme type with stack of dictionaries
and this has nothing with language.
international search, without having to associate a specific language to the
ts_vector ? I must admit that it's quite ambiguous, but let's imagine that
you have a worldwide address repository. In that case, you can find "Rue",
"Street", "Strasse" etc... which have all a low significancy.
This particular problem can be solved using synonym dictionary, for example.
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
Thanks for your answer,
Could you point me to documentation regarding the configuration (dictionary
creation, synonym creation) of FTS and how to do it ?
Thanks,
Cédric
2010/3/22 Oleg Bartunov <oleg@sai.msu.su>
On Sun, 21 Mar 2010, C?dric MOULLET wrote:
Hi,
I have the following problem with the FTS: the database contains
information
in several languages. As I understand, the FTS requires to associate a
language when ts_vector is created. Is there any way to make a kind ofFTS doesn't needs to be asscociated with specific language ! FTS requires
its configuration, which binds specific lexeme type with stack of
dictionaries
and this has nothing with language.international search, without having to associate a specific language to
the
ts_vector ? I must admit that it's quite ambiguous, but let's imagine that
you have a worldwide address repository. In that case, you can find "Rue",
"Street", "Strasse" etc... which have all a low significancy.This particular problem can be solved using synonym dictionary, for
example.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/<http://www.sai.msu.su/%7Emegera/>
phone: +007(495)939-16-83, +007(495)939-23-83
--
Welcome to my world: http://www.cedricmoullet.com/
My Linked In profile: http://www.linkedin.com/in/cedricmoullet
Twitter: http://twitter.com/cedricmoullet