Re: Tsearch2 Spanish Dictionary

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Mario Ignacio Rodríguez Cortés <ignacio(dot)cortes(at)inegi(dot)gob(dot)mx>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Tsearch2 Spanish Dictionary
Date: 2008-04-21 17:22:46
Message-ID: 20080421172246.GE14464@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mario Ignacio Rodríguez Cortés wrote:

> But in postgresql-8.3.1:
>
> SELECT to_tsvector('spanish','estadística');
> to_tsvector
> -------------
> 'stic':2
> (1 row)

It works for me:

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

alvherre=# select version();
version
------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 8.4devel on x86_64-unknown-linux-gnu, compiled by GCC gcc-4.1 (GCC) 4.1.3 20080114 (prerelease) (Debian 4.1.2-19)
(1 fila)

So I'm thinking you've got encoding problems. Did you set up
client_encoding appropriately?

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Colin Wetherbee 2008-04-21 17:34:16 Storing computed values
Previous Message Shane Ambler 2008-04-21 16:58:20 Re: help with "plpgsql"