type case string to float column in select query postgresql code example
Example 1: postgresql convert text to float
select cast('132342' as double precision);
Example 2: postgresql cast
SELECT '100'::INTEGER;
SELECT CAST ('100' AS INTEGER);
select cast('132342' as double precision);
SELECT '100'::INTEGER;
SELECT CAST ('100' AS INTEGER);