Tsearch2 Spanish Dictionary

From: Mario Ignacio Rodríguez Cortés <ignacio(dot)cortes(at)inegi(dot)gob(dot)mx>
To: pgsql-general(at)postgresql(dot)org
Subject: Tsearch2 Spanish Dictionary
Date: 2008-04-21 16:39:51
Message-ID: 1208795991.5762.22.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All:

I have installed postgresql 8.3.1 on a Gentoo server, but i think that
the spanish dictionary isn't the correct because i have another two
machines with other postgresql versions and tserch2 installed, and a
simple test that i do is make a query with the spanish dictionary, i get
the follow results, the problem that i saw is in the accent, if i put a
word with accent doesn't work:

In postgresql-8.1.8:

SELECT to_tsvector('spanish','estadística');
to_tsvector
--------------
'estadist':1
(1 fila)

In postgresql-8.2.4:

SELECT to_tsvector('spanish','estadística');
to_tsvector
--------------
'estadist':1
(1 fila)

But in postgresql-8.3.1:

SELECT to_tsvector('spanish','estadística');
to_tsvector
-------------
'stic':2
(1 row)

whitout accent:

SELECT to_tsvector('spanish','estadistica');
to_tsvector
-------------
'estadist':2
(1 row)

what should i do to make it work well?

Thanks.

Mario Rdz.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shane Ambler 2008-04-21 16:58:20 Re: help with "plpgsql"
Previous Message Christophe 2008-04-21 16:30:52 Re: help with "plpgsql"