Hello!
My queries work fine with Regular Expressions, as:
SELECT field FROM table WHERE field ~ 'something';
SELECT field FROM table WHERE field ~* 'something';
SELECT field FROM table WHERE field ~* 'som[i,e]thing';
And it works fine for special characters:
SELECT field FROM table WHERE field ~* 'chão';
But I just can't make it work correctly using brackets:
SELECT field FROM table WHERE field ~* 'ch[aã]o';
It just returns tuples that have 'chao', but not 'chão'.
My queries are utf-8 an the database is SQL_ASCII.
Any idea? Thank you!
--
Silas Justiniano - Brazil
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
