Avoid casting NULLs in UNION...

[Marko Rihtar <rihtar.marko@xxxxxxxxx>]

Hi,

maybe you can help me with this issue.
Here is an example

SELECT NULL::integer

UNION ALL

SELECT NULL

UNION ALL

SELECT 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?

thanks for help,
Marko