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.
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" |