By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 10
| id | status | is_int | after_cast |
|---|---|---|---|
| 1 | 12 | t | 12 |
| 2 | foo | f | invalid: foo |
| 3 | bar2 | f | invalid: bar2 |
| 4 | -123 | t | -123 |
| 5 | - 123 | f | invalid: - 123 |
| 6 | -12.5 | f | invalid: -12.5 |
| 7 | +5 | t | 5 |
| 8 | +1e6 | f | invalid: +1e6 |
| 9 | 1 | f | invalid: 1 |
| 10 | -12.5 | f | invalid: -12.5 |
SELECT 10