Postgres Pro
Downloads
Home   >   mailing lists

Avoid casting NULLs in UNION... - Mailing list pgsql-admin

From Marko Rihtar
Subject Avoid casting NULLs in UNION...
Date
Msg-id CABSSDoH3A7qfFnY6UExqjYKOTxox0=r0jt4_PWrhL4-u0yP2kQ@mail.gmail.com
Whole thread Raw
Responses Re: Avoid casting NULLs in UNION...  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-admin
Tree view
Hi,

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?

thanks for help,
Marko

pgsql-admin by date:

Previous
From: "Gunnar \"Nick\" Bluth"
Date:
Subject: Re: postgres 9.0 - unable to bind to localhost.
Next
From: Albe Laurenz
Date:
Subject: Re: Avoid casting NULLs in UNION...