SET CONCAT_NULL_YIELDS_NULL

Controls whether concatenation results are treated as null or empty string values.

Syntax

SET CONCAT_NULL_YIELDS_NULL { ON | OFF } [;]

Remarks

Argument values are ignored and do not change the default behavior.

Permissions

Requires membership in the public role.

See Also