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.
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? |