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])

Reply via email to