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#