Annotation: core.append_if_not_null

CREATE OR REPLACE FUNCTION core.append_if_not_null(text, text)
RETURNS text

Information: core.append_if_not_null

Schema	core
Function Name	append_if_not_null
Arguments	text, text
Owner	postgres
Result Type	text
Description

Implementation: core.append_if_not_null

CREATE OR REPLACE FUNCTION core.append_if_not_null(text, text)
 RETURNS text
 LANGUAGE plpgsql
 IMMUTABLE
AS $function$
BEGIN
	IF($1 IS NULL) THEN
	    RETURN '';
	END IF;

	RETURN $1 || $2;
END
$function$