postgres to int 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);