Re: search on accents -> Why not include this function

From: Jaume Teixi <teixi(at)6tems(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-admin(at)postgresql(dot)org, Patrice Hd <patrice(dot)hede(at)idf(dot)net>
Subject: Re: search on accents -> Why not include this function
Date: 2001-03-29 17:44:35
Message-ID: 20010329194435.45990809.teixi@6tems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

on day of Tue, 27 Mar 2001 19:24:34 +0200 (CEST), the message from Peter
Eisentraut <peter_e(at)gmx(dot)net> says:

> Jaume Teixi writes:
>
> > this c function from Patrice Hédé is the most appropiate tool for
> > searching on an accent based language ?
> > http://www.postgresql.org/mhonarc/pgsql-sql/1998-06/msg00119.html
>
> Looks good to me.
>
> > or should I use an implemented function inside postgres right now ?
>
> The reason there is no such implementation, and probably won't be any
time
> soon, is that this tool would either have to hard-code or ignore natural
> language semantics, neither of which would make it practical. Not all
> languages have the same accent ignoring or accent folding rules or
> conventions.

This function is really fast.
The accent method is a REAL need for almost all non-english languages.
You should to explicity call this funciton like:
select accents ('dali');
accents
----------------------------------
[dðÐ][aáÁàÀâÂäÄåÅãÃ]l[iíÍìÌîÎïÏ]

so why to not to include on the next release ?

best from barcelona,

jaume teixi.

This fortune intentionally not included.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2001-03-29 17:53:55 Re: PG 7.0.3 & RH 7 IPC problems?
Previous Message Stefan Huber 2001-03-29 17:23:25 Re: PG 7.0.3 & RH 7 IPC problems?