Re: CONCAT returns null

Adrian Klaver <adrian.klaver@aklaver.com> wrote:

>>
>> NULL concat with a value returns NULL. You can avoid that using
>> COALESCE(value, ''), that returns the value, or, if the value NULL, ''.
>
>
> http://www.postgresql.org/docs/9.5/interactive/functions-string.html
> "
> concat(str "any" [, str "any" [, ...] ])     text     Concatenate the text
> representations of all the arguments. NULL arguments are ignored.
> "

you are right, my fault :-(, muddled with the || - operator.


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°