Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION format_cpf(pcpf_input text, panon bool DEFAULT FALSE) RETURNS text AS $$
- DECLARE
- v_cpf_clean text;
- BEGIN
- v_cpf_clean := regexp_replace(pcpf_input, '[^0-9]', '', 'g');
- IF length(v_cpf_clean) != 11 THEN
- return v_cpf_clean;
- END IF;
- IF(panon)THEN
- RETURN format('***.%s.%s-**',
- substring(v_cpf_clean, 4, 3),
- substring(v_cpf_clean, 7, 3));
- END IF;
- RETURN format('%s.%s.%s-%s',
- substring(v_cpf_clean, 1, 3),
- substring(v_cpf_clean, 4, 3),
- substring(v_cpf_clean, 7, 3),
- substring(v_cpf_clean, 10, 2));
- END;
- $$ LANGUAGE plpgsql IMMUTABLE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
