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