(Note) Chuyển đổi tiếng việt không dấu trong PostgreSQL.

-- FUNCTION: public.converttvkdau(text)

-- DROP FUNCTION public.converttvkdau(text);

CREATE OR REPLACE FUNCTION public.converttvkdau(
x text)
RETURNS text
    LANGUAGE 'plpgsql'
    COST 100
    VOLATILE
AS $BODY$
DECLARE
   codau text; kdau text; r text;
BEGIN
   codau = 'áàảãạâấầẩẫậăắằẳẵặđéèẻẽẹêếềểễệíìỉĩịóòỏõọôốồổỗộơớờởỡợúùủũụưứừửữựýỳỷỹỵÁÀẢÃẠÂẤẦẨẪẬĂẮẰẲẴẶĐÉÈẺẼẸÊẾỀỂỄỆÍÌỈĨỊÓÒỎÕỌÔỐỒỔỖỘƠỚỜỞỠỢÚÙỦŨỤƯỨỪỬỮỰÝỲỶỸỴ';
   kdau  = 'aaaaaaaaaaaaaaaaadeeeeeeeeeeeiiiiiooooooooooooooooouuuuuuuuuuuyyyyyAAAAAAAAAAAAAAAAADEEEEEEEEEEEIIIIIOOOOOOOOOOOOOOOOOUUUUUUUUUUUYYYYY';
   r = x;
   FOR i IN 0..length(codau)
   LOOP
        r = replace(r, substr(codau,i,1), substr(kdau,i,1));
   END LOOP;
   RETURN r;
END;
$BODY$;

ALTER FUNCTION public.converttvkdau(text)
    OWNER TO postgres;