Hi Augusto,
> How can I configure postgreSQL to search without acents?
> Is PostgreSQL have this support?
>
There isn't a specific function in postgresql. Maybe you could implement it in PL/Perl
or any other PL/* language.
> SELECT * FROM test WHERE name LIKE _tes%_
>
> And it should return values _t�st, test_
>
It's not a good idea to use _ to replace accents 'cause it would match undesirable
expressions like tost, tist, tust, txst, etc.
--
Euler Taveira de Oliveira
euler (at) ufgnet.ufg.br
Desenvolvedor Web e Administrador de Sistemas
UFGNet - Universidade Federal de Goi�s
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])