On Wed, 18 Sep 2002 [EMAIL PROTECTED] wrote: > Greetings, > > As far as I use the txtidx data structure in conjunction with gist indexing > to make a word indexing of a very large UNICODE db, I've implemented a PostgreSQL > function that uses libunac to unaccent TEXT fileds. > > The resulting text is in UTF-8, but you can modify it in the sources with > an appropriate value (using iconv charset names). > > Get libunac from: http://www.nongnu.org/unac/ (it uses iconv) > > Extract the archive, compile it (make). Move pg_unac.so to your postgresql > shared libraries dir. > > Link it in postgresql: > > CREATE FUNCTION unac(TEXT) RETURNS TEXT AS 'path_to_pg_unac.so' LANGUAGE > C; > > What about integrating unaccent libraries directly in tsearch? It is useful > for french search engines (for instance).
I think better to have separate module contrib/unac and document using it with tsearch. Please write us a couple of lines about using your function and we'll add them into tsearch documentation. btw, use palloc instead of malloc in postgresql functions . > > Bye. > > Nhan NGO DINH > > > __________________________________________________________________ > Tiscali Ricaricasa > la prima prepagata per navigare in Internet a meno di un'urbana e > risparmiare su tutte le tue telefonate. Acquistala on line e non avrai > nessun costo di attivazione né di ricarica! > http://ricaricasaonline.tiscali.it/ > > > > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly