Re: CONCAT returns null

Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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°