CODE EXAMPLE FOR SQL

postgresql convert text to float

select cast('132342' as double precision);