convert to int postgresql 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);
SELECT ' 5800.79 '::INTEGER;
SELECT '100'::INTEGER;
SELECT CAST ('100' AS INTEGER);