| 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: | Whole Thread | Raw Message | 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" |