Re: [ADMIN] Avoid casting NULLs in UNION...

2013-02-03 Thread Marko Rihtar
OK Albe, thanks for info 2013/2/1 Albe Laurenz > Marko Rihtar wrote: > > 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 w

Re: [ADMIN] Avoid casting NULLs in UNION...

2013-02-01 Thread Albe Laurenz
Marko Rihtar wrote: > 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 > leve

[ADMIN] Avoid casting NULLs in UNION...

2013-02-01 Thread Marko Rihtar
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 n