Re: search on accents over all possible matches - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: search on accents over all possible matches
Date
Msg-id Pine.LNX.4.30.0103271919550.1215-100000@peter.localdomain
Whole thread Raw
In response to search on accents over all possible matches  (Jaume Teixi <teixi@6tems.com>)
Responses Re: search on accents -> Why not include this function  (Jaume Teixi <teixi@6tems.com>)
List pgsql-admin
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.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


pgsql-admin by date:

Previous
From: David Lizano
Date:
Subject: Re: search on accents over all possible matches
Next
From: Bruce Momjian
Date:
Subject: pgmonitor 0.30 released