-- Name: derived_col_name_from_check_constraint(check_constraint_def); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION derived_col_name_from_check_constraint(check_constraint_def check_constraint_def) RETURNS text

    LANGUAGE sql IMMUTABLE

    AS $_$

-- **IMPORTANT**: need to remove the enclosing () to be consistent everywhere

SELECT (SELECT regexp_matches(

	util.trim_parens(util.remove_prefix($$NOT $$, util.trim_parens(

		util.check_constraint_expr_enable(check_constraint_def.expr)

	), require := true))

, $$^(.*?) IS DISTINCT FROM $$))[1]

$_$;

--