Re: search on accents -> Why not include this function - Mailing list pgsql-admin

From Jaume Teixi
Subject Re: search on accents -> Why not include this function
Date
Msg-id 20010329194435.45990809.teixi@6tems.com
Whole thread Raw
In response to Re: search on accents over all possible matches  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: search on accents -> Why not include this function  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-admin
on day of Tue, 27 Mar 2001 19:24:34 +0200 (CEST), the message from Peter
Eisentraut <peter_e@gmx.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.

pgsql-admin by date:

Previous
From: DHSC Webmaster
Date:
Subject: Re: PG 7.0.3 & RH 7 IPC problems?
Next
From: Tom Lane
Date:
Subject: Re: PG 7.0.3 & RH 7 IPC problems?