Postgres HTML Tag Remover

postgres_html_remover.sql

CREATE OR REPLACE FUNCTION REMOVE_HTML_TAGS(TEXT) RETURNS TEXT AS
$$
DECLARE
    INPUT_TEXT ALIAS FOR $1;
    CLEAN_TEXT TEXT;
BEGIN
    -- Remove Tags (e.g. <p>, <a>, <div>)
    CLEAN_TEXT := REGEXP_REPLACE(INPUT_TEXT, '<[^>]+>', '', 'g');

    -- Remove entities (e.g. &nbsp;)
    CLEAN_TEXT := REGEXP_REPLACE(CLEAN_TEXT,
                                 '&([a-z0-9]+|#[0-9]{1,6}|#x[0-9a-f]{1,6});',
                                 '', 'g');

    RETURN CLEAN_TEXT;
END;
$$ LANGUAGE PLPGSQL;