-- Name: derived_cols(regclass, regclass); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION derived_cols(table_ regclass, names regclass) RETURNS SETOF text

    LANGUAGE sql STABLE STRICT

    AS $_$

SELECT util.eval2set($$

SELECT col

FROM util.col_names($$||quote_nullable($1)||$$::regclass) f (col)

LEFT JOIN $$||$2||$$ ON "to" = col

WHERE "from" IS NULL

$$, NULL::text)

$_$;

--

-- Name: FUNCTION derived_cols(table_ regclass, names regclass); Type: COMMENT; Schema: util; Owner: -

--

COMMENT ON FUNCTION derived_cols(table_ regclass, names regclass) IS 'gets table_''s derived columns (all the columns not in the names table)';

--