| From: | Euler Taveira de Oliveira <euler(at)ufgnet(dot)ufg(dot)br> |
|---|---|
| To: | "Augusto Cesar Castoldi" <castoldi(at)npd(dot)ufsc(dot)br> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Seaching without accents |
| Date: | 2004-02-03 17:40:09 |
| Message-ID: | 20040203154009.314cbaf8.euler@ufgnet.ufg.br |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2004-02-03 18:10:46 | Re: [PATCHES] log session end - again |
| Previous Message | Tom Lane | 2004-02-03 16:56:06 | Re: [PATCHES] log session end - again |