Advertisement
Guest User

Untitled

a guest
Sep 3rd, 2015
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.33 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION "public"."normalizetxt" (CHARACTER VARYING)  RETURNS CHARACTER VARYING
  2.   VOLATILE
  3. AS $dbvis$
  4. SELECT TRANSLATE(TRANSLATE($1, 'áéíóúàèìòùãõâêîôôäëïöüçÁÉÍÓÚÀÈÌÒÙÃÕÂÊÎÔÛÄËÏÖÜÇ', 'aeiouaeiouaoaeiooaeioucAEIOUAEIOUAOAEIOOAEIOUC'), '''"', ' ')
  5. $dbvis$ LANGUAGE SQL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement