String concatenation with a null seems to nullify the entire string – is that desired behavior in Postgres?

Quote from documentation

Concatenate all arguments. NULL arguments are ignored.

Example

concat('abcde', 2, NULL, 22) 

Returns

abcde222

See more in Documentation