Re: Re: [pgsql-es-ayuda] Re: [pgsql-es-ayuda] Re: [pgsql-es-ayuda] Tsearch2: realizar búsqueda sin acentos

Vanessa dijo [Mon, Feb 09, 2009 at 11:19:08AM -0300]:
> Gracias por tu respuesta, pero lamentablemente no puedo cambiarme de versión
> en postgres, vere como puedo arreglarlo

¿Qué sistema operativo usas? En casi todas las distribuciones basadas
en Linux, tu proveedor tendrá varios paquetes - Especialmente te
interesa postgresql (o postgresql-server, o algo equivalente), que es
el servidor propiamente dicho, y postgresql-contrib, que incluye a
tsearch2 y a muchos lenguajes pre-cargados. Por ejemplo, en Debian:

gwolf=# SELECT * from pg_ts_config;
cfgname | cfgnamespace | cfgowner | cfgparser
------------+--------------+----------+-----------
simple | 11 | 10 | 3722
danish | 11 | 10 | 3722
dutch | 11 | 10 | 3722
english | 11 | 10 | 3722
finnish | 11 | 10 | 3722
french | 11 | 10 | 3722
german | 11 | 10 | 3722
hungarian | 11 | 10 | 3722
italian | 11 | 10 | 3722
norwegian | 11 | 10 | 3722
portuguese | 11 | 10 | 3722
romanian | 11 | 10 | 3722
russian | 11 | 10 | 3722
spanish | 11 | 10 | 3722
swedish | 11 | 10 | 3722
turkish | 11 | 10 | 3722
(16 rows)

gwolf=# SELECT * from pg_ts_dict ;
dictname | dictnamespace | dictowner | dicttemplate | dictinitoption
-----------------+---------------+-----------+--------------+---------------------------------------------------
simple | 11 | 10 | 3727 |
danish_stem | 11 | 10 | 11282 | language = 'danish', stopwords = 'danish'
dutch_stem | 11 | 10 | 11282 | language = 'dutch', stopwords = 'dutch'
english_stem | 11 | 10 | 11282 | language = 'english', stopwords = 'english'
finnish_stem | 11 | 10 | 11282 | language = 'finnish', stopwords = 'finnish'
french_stem | 11 | 10 | 11282 | language = 'french', stopwords = 'french'
german_stem | 11 | 10 | 11282 | language = 'german', stopwords = 'german'
hungarian_stem | 11 | 10 | 11282 | language = 'hungarian', stopwords = 'hungarian'
italian_stem | 11 | 10 | 11282 | language = 'italian', stopwords = 'italian'
norwegian_stem | 11 | 10 | 11282 | language = 'norwegian', stopwords = 'norwegian'
portuguese_stem | 11 | 10 | 11282 | language = 'portuguese', stopwords = 'portuguese'
romanian_stem | 11 | 10 | 11282 | language = 'romanian'
russian_stem | 11 | 10 | 11282 | language = 'russian', stopwords = 'russian'
spanish_stem | 11 | 10 | 11282 | language = 'spanish', stopwords = 'spanish'
swedish_stem | 11 | 10 | 11282 | language = 'swedish', stopwords = 'swedish'
turkish_stem | 11 | 10 | 11282 | language = 'turkish', stopwords = 'turkish'
(16 rows)

Y como puedes ver, todos estos van con las reglas Snowball y lista de
palabras ignorables correspondientes (a excepción, por lo visto, del
rumano).

Saludos,

--
Gunnar Wolf - gwolf(at)gwolf(dot)org - (+52-55)5623-0154 / 1451-2244
PGP key 1024D/8BB527AF 2001-10-23
Fingerprint: 0C79 D2D1 2C4E 9CE4 5973 F800 D80E F35A 8BB5 27AF