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