-- Name: derived_col_update(derived_col_def); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION derived_col_update(def derived_col_def) RETURNS void

    LANGUAGE sql

    AS $$

SELECT util.col_add(def);

-- if table has data, initially disabled because not yet populated

SELECT util.check_constraint((def.col, util.derived_col_constraint_expr(def)),

	enabled := NOT util.table_has_data((def).col.table_));

-- create the trigger

SELECT util.derived_cols_sync((def).col.table_);

$$;

--

-- Name: FUNCTION derived_col_update(def derived_col_def); Type: COMMENT; Schema: util; Owner: -

--

COMMENT ON FUNCTION derived_col_update(def derived_col_def) IS '

**IMPORTANT**: unless the table is empty, remember to run

util.derived_cols_populate() after this

usage:

SELECT util.derived_col_update(((''table'', ''col1''), $$col1_expr$$));

SELECT util.derived_col_update(((''table'', ''col2''), $$col2_expr$$));

-- if table has data:

SELECT util.derived_cols_populate(''table'');

idempotent

';

--