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