2009/3/18 Pedro Doria Meunier <pdoria@xxxxxxxxxxxxxx>
ILIKE is only case-insensitive, and won't match accented characters. The only thing I can think of doing is to create a function which will replace characters with their equivalent non-accented counterparts and use that in the query.
Example: SELECT name FROM people WHERE unaccent_string(name) ~* 'Pédro';
The function would perform a reg-ex replace similar to: s/[èééêë]/e
Just an idea
Thom
Hi,
use ILIKE
HTH,
ILIKE is only case-insensitive, and won't match accented characters. The only thing I can think of doing is to create a function which will replace characters with their equivalent non-accented counterparts and use that in the query.
Example: SELECT name FROM people WHERE unaccent_string(name) ~* 'Pédro';
The function would perform a reg-ex replace similar to: s/[èééêë]/e
Just an idea
Thom
