Postgresql 3 digit or money seperator function

money format function.sql

CREATE or replace FUNCTION money_format(amount int)
    RETURNS text AS $$
        BEGIN
            return trim(to_char(amount, '999,999,999,999,999,999,999,999,999,999'));
        END;
    $$
LANGUAGE plpgsql;

CREATE or replace FUNCTION money_format(amount bigint)
    RETURNS text AS $$
        BEGIN
            return trim(to_char(amount, '999,999,999,999,999,999,999,999,999,999'));
        END;
    $$
LANGUAGE plpgsql;

CREATE OR REPLACE FUNCTION money_format(amount text)
    RETURNS text AS $$
        BEGIN
            -- check if amount has decimal points
            if (amount::decimal % 1 != 0) then
                return trim(to_char(amount::decimal, '999,999,999,999,999,999,999,999,999,999.999'));
            else
                return trim(to_char(amount::bigint, '999,999,999,999,999,999,999,999,999,999'));
            end if;


        END;
    $$
LANGUAGE plpgsql;

CREATE OR REPLACE FUNCTION money_format(amount decimal)
    RETURNS text AS $$
        BEGIN
            -- check if amount has decimal points
            if (amount % 1 != 0) then
                return trim(to_char(amount::decimal, '999,999,999,999,999,999,999,999,999,999.999'));
            else
                return trim(to_char(amount::decimal, '999,999,999,999,999,999,999,999,999,999'));
            end if;


        END;
    $$
LANGUAGE plpgsql;