Re: [GENERAL] TSearch - Bulgarian

Hi Christian,
Yes we know that we need to create Bulgarian dictionary first. Dictionaries like programs, and dictionaries like word list of our language. The Programs Dictionaries bothers me the most :-). Also how many word list dictionaries we need to build? 1. Stop words. 2. ??? currently we don’t need to make spell check so I guess we don’t have to build ispell dictionaries. I'm reading the guides one by one from the http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/, but I guess I'm just not good enough to find what we need.

-----Original Message-----
From: Christian Rengstl [mailto:Christian.Rengstl@klinik.uni-regensburg.de] Sent: Thursday, September 27, 2007 4:43 PM To: Hristo Filipov; pgsql-general@postgresql.org Subject: Re: [GENERAL] TSearch - Bulgarian

You might have to create a Bulgarian dictionary first before you will be able to successfully use tsearch. Maybe some information here will help you:
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/

Christian Rengstl M.A.
Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung
Universitätsklinikum Regensburg
B3 1.388
Franz-Josef-Strauss-Allee 11
93053 Regensburg
Tel.: +49-941-944-7230

>>> On Thu, Sep 27, 2007 at 3:17 PM, in message <003c01c80108$b550d9c0$1ff28d40$@net>, "Hristo Filipov" <christod@ciela.net>
wrote:
> Hello world!
>
> J!! We are Bulgarian developers currently working on some web
project(server
> must run on windows and linux) and we stop our choice for database
at
> PostgreSQL, which I may say offers great things at no cost at all :-
P.
>
> So we have our tables ready after some times (new for psql,
migrating
> database from access) all works fine! Even better! But we can't get
to run
> FTS on PostgreSQL L. We have tables in locale
Bulgaria_Bulgarian_1251,
> Bulgaria_Bulgarian_UTF8. I read "Full- Text Search in PostgreSQL - A
Gentle
> Introduction" from Oleg Bartunov and Teodor Sigaev (great work
guys!), and
> it open my eyes in some way, but I still can't understand what I need
to do
> - so I can create FTS for Bulgarian language L and make TSearch work
for us.
> Can someone help us?
>
>
>
> Hristo Filipov

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match