Avoid casting NULLs in UNION...

Поиск
Список
Период
Сортировка
От Marko Rihtar
Тема Avoid casting NULLs in UNION...
Дата
Msg-id CABSSDoH3A7qfFnY6UExqjYKOTxox0=r0jt4_PWrhL4-u0yP2kQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Avoid casting NULLs in UNION...
Список pgsql-admin
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 по дате отправления: