On Wed, 18 Sep 2002 [EMAIL PROTECTED] wrote: > The best way to use it is quite simple. If you want to index the table "titles" > and "title" is the field containing the text to be indexed, you can create > another unaccented field, for instance "utitle". > > UPDATE titles SET utitle = unac(title); > > Of course you can set it up as a trigger function. Then you can use utitle > with txt2txtidx and tsearch. > > Another solution is to generate the txtidx field (i.e. titleidx) directly > using unac: > > UPDATE titles SET titleidx = txt2txtidx(unac(title)); > > But the problem is that I've not succeeded using it with tsearch because > (of course) it doesn't allow functions as parameters. So my first idea was > to integrate unac in tsearch.
what's exactly a problem ? UPDATE titles SET titleidx = txt2txtidx(unac(title)); works fine. Perhaps, you have a problem with query ? > > Bye. > > >-- Messaggio Originale -- > >Date: Wed, 18 Sep 2002 15:08:59 +0300 (GMT) > >From: Oleg Bartunov <[EMAIL PROTECTED]> > >To: [EMAIL PROTECTED] > >Cc: [EMAIL PROTECTED] > >Subject: Re: [HACKERS] unaccent > > > > > >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 > > > > __________________________________________________________________ > 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/ > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > 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 6: Have you searched our list archives? http://archives.postgresql.org
