maybe you can help me with this issue. Here is an example
SELECT NULL::integer
UNION ALL
SELECT NULL
UNION ALLSELECT 123
For this sql to work i have to cast NULL to integer. I was wondering if there exists some configuration parameter at database level that can be used to avoid this need for explicit casting?