What does SELECT 'Hi, ' || 'there', 'Hi, ' || NULL output?

Console output

Why

The || operator concatenates strings, but if either side is NULL the whole result is NULL. This is why string building over nullable columns often needs COALESCE to avoid silently producing NULL.