Postgres formatacoes - 09 07 09 05:36

SELECT to_number('123,2', '999999999'); -- 1232
SELECT to_number('123,2', '9999999d99') -- 123.2
SELECT to_number('123,456,789.00', '999G999G999D99') AS formatted;
SELECT to_number('89', '00999999999')
SELECT to_number('$2,900.00', 'L9G999D99')