Re: Seaching without accents - Mailing list pgsql-general

Augusto Cesar Castoldi wrote:

>
>
> SELECT * FROM test WHERE name LIKE “tes%”
>
>
>
> And it should return values “tést, test”
>

Why not using a regular expression, like this:



yomama=# select * from test;
  name
------
  test
  tést
  tèst
  tast
(4 rows)

yomama=# select * from test where name ~ '^t[eéè]s';
  name
------
  test
  tést
  tèst
(3 rows)


   Bernd