#casting

PostgreSQL "invalid input syntax for type integer": find the bad value and handle it

Fix "invalid input syntax for type integer": find empty strings and text where a number is expected, convert with NULLIF and pg_input_is_valid, import clean data.

Beginner · 3 min read