CODE EXAMPLE FOR SQL

postgres convert text to number

SELECT ' 5800.79 '::INTEGER;