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.