-- Name: mk_derived_col(col_ref, text); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION mk_derived_col(col col_ref, expr text) RETURNS void

    LANGUAGE plpgsql STRICT

    AS $_$

DECLARE

    type regtype = util.typeof(expr, col.table_::text::regtype);

    col_name_sql text = quote_ident(col.name);

BEGIN

    PERFORM util.create_if_not_exists($$

ALTER TABLE $$||col.table_||$$ ADD   COLUMN $$||col_name_sql||$$      $$||type||$$;

ALTER TABLE $$||col.table_||$$ ALTER COLUMN $$||col_name_sql||$$ TYPE $$||type||$$ USING

$$||expr||$$;

$$);

END;

$_$;

--