postgresql — codestacker

you are in: codestacker → codes [RSS] → tag: postgresql [RSS]

Função para remover acentos em PostgreSQL

Funçãozinha em PostgreSQL para remover acentos. Útil para buscar resultados independente da acentuação.

show/hide lines

   1  CREATE OR REPLACE FUNCTION sem_acentos(character varying)
   2    RETURNS character varying AS
   3  $BODY$
   4  	SELECT TRANSLATE($1, 'áéíóúàèìòùãõâêîôôäëïöüçÁÉÍÓÚÀÈÌÒÙÃÕÂÊÎÔÛÄËÏÖÜÇ', 'aeiouaeiouaoaeiooaeioucAEIOUAEIOUAOAEIOOAEIOUC')
   5  $BODY$
   6    LANGUAGE 'sql' VOLATILE;

CREATE OR REPLACE FUNCTION sem_acentos(character varying)
  RETURNS character varying AS
$BODY$
	SELECT TRANSLATE($1, 'áéíóúàèìòùãõâêîôôäëïöüçÁÉÍÓÚÀÈÌÒÙÃÕÂÊÎÔÛÄËÏÖÜÇ', 'aeiouaeiouaoaeiooaeioucAEIOUAEIOUAOAEIOOAEIOUC')
$BODY$
  LANGUAGE 'sql' VOLATILE;

created by bragil — 24 July 2008 — get a short url — tags: postgresql — embed