-- create a diff when the # of copies of a row differs between the tables

SELECT util.to_freq($1);

SELECT util.to_freq($2);

SELECT util.eval($$ALTER TABLE $$||util.typeof($3)||$$ ADD COLUMN copies bigint NOT NULL$$);

SELECT * FROM util.diff($1, $2, $3, has_freq := true)

col_type_null (*required*): NULL::shared_base_type

-- Name: diff(regclass, regclass, anyelement, boolean); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION diff(left_table regclass, right_table regclass, col_type_null anyelement, has_freq boolean, OUT left_ anyelement, OUT right_ anyelement) RETURNS SETOF record

    LANGUAGE sql

    AS $_$

SELECT * FROM util.diff($1::text, $2::text, $3,

	single_row := util.has_single_row($1) AND util.has_single_row($2))

$_$;

--

-- Name: FUNCTION diff(left_table regclass, right_table regclass, col_type_null anyelement, has_freq boolean, OUT left_ anyelement, OUT right_ anyelement); Type: COMMENT; Schema: util; Owner: -

--

COMMENT ON FUNCTION diff(left_table regclass, right_table regclass, col_type_null anyelement, has_freq boolean, OUT left_ anyelement, OUT right_ anyelement) IS '

helper function used by diff(regclass, regclass)

usage:

SELECT * FROM util.diff(''"left_freq_table"''::regclass, ''"right_freq_table"''::regclass, NULL::shared_base_type, has_freq := true)

col_type_null (*required*): NULL::shared_base_type

';

--