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