2009/3/18 Pedro Doria Meunier <pdo...@netmadeira.com>

> 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


Reply via email to