postgres type cast string to int code example

Example: postgresql cast

SELECT '100'::INTEGER;
SELECT CAST ('100' AS INTEGER);