text to numeric in postgres code example Example: postgresql convert text to float select cast('132342' as double precision);