Appending null produces null?

Поиск
Список
Период
Сортировка
От Jeff Eckermann
Тема Appending null produces null?
Дата
Msg-id 08CD1781F85AD4118E0800A0C9B8580B09479B@NEZU
обсуждение исходный текст
Ответы Re: Appending null produces null?  (Alex Pilosov <alex@pilosoft.com>)
Список pgsql-general
extracts=# select bill_address1, bill_address2, bill_address1 || ' ' ||
bill_address2 from customers where external_id = 20037514;
  bill_address1  | bill_address2 | ?column?
-----------------+---------------+----------
 6745 Avalon Ave |               |
(1 row)

I know that the usual operations with 'null' will produce null, but I didn't
expect it in the case of a text field being appended to another text field.
No doubt that follows as a matter of strict principle, but the outcome makes
no sense from a purely practical point of view.  Is this really the intended
behaviour?  I know that I can work around this with a 'coalesce' or
something similar, but that seems unnecessarily messy.

В списке pgsql-general по дате отправления:

Предыдущее
От: "Mateusz"
Дата:
Сообщение: mateo
Следующее
От: Alex Pilosov
Дата:
Сообщение: Re: Appending null produces null?