Created
May 10, 2013 00:34
-
-
Save rafaelchagasb/5551656 to your computer and use it in GitHub Desktop.
Consulta de strings sem o acento.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Consulta de strings sem o acento. | |
select * from nomeDaSuaTabela where sem_acento(colunaDaTabela) iLIKE sem_acento('SUA STRING') | |
-- Exemplo: | |
select * from municipio where sem_acento(nome) iLIKE sem_acento('SãO PAULO') | |
-- O trecho abaixo precisa ser executado somente uma vez no banco que você for usar a função. | |
CREATE FUNCTION sem_acento(text) RETURNS text AS $$ | |
SELECT translate($1,'ÀÁÂÃÄÅAAAÈÉÊËEEEEEÌÍÎÏIIIIÒÓÔÕÖØOOOÙÚÛÜUUUUUUàáâãäåaaaèéêëeeeeeìíîïiiiiòóôõöøoooùúûüuuuuuÇçÑñÝýÿCcCcCcCcDdÐdGgGgGgGgHhHh', | |
'AAAAAAAAAEEEEEEEEEIIIIIIIIOOOOOOOOOUUUUUUUUUUaaaaaaaaaeeeeeeeeeiiiiiiiiooooooooouuuuuuuuuCcNnYyyCcCcCcCcDdDdGgGgGgGgHhHh'); | |
$$ | |
LANGUAGE sql IMMUTABLE STRICT; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment