Re: search on accents -> Why not include this function
От | Jaume Teixi |
---|---|
Тема | Re: search on accents -> Why not include this function |
Дата | |
Msg-id | 20010329194435.45990809.teixi@6tems.com обсуждение исходный текст |
Ответ на | Re: search on accents over all possible matches (Peter Eisentraut <peter_e@gmx.net>) |
Ответы |
Re: search on accents -> Why not include this function
|
Список | 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 по дате отправления: