postgresql string to integer code example

Example 1: postgres convert text to number

SELECT ' 5800.79 '::INTEGER;

Example 2: postgresql cast

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