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

--

CREATE FUNCTION remake_diff_table(diff_table text, left_table regclass, right_table regclass, type_table text) RETURNS void

    LANGUAGE sql

    AS $_$

/* can't have in_table/out_table inherit from *each other*, because inheritance

also causes the rows of the parent table to be included in the child table.

instead, they need to inherit from a common, empty table. */

SELECT util.drop_table($4, force := true);

SELECT util.copy_struct($2, $4);

SELECT util.inherit($2, $4);

SELECT util.inherit($3, $4);

SELECT util.rematerialize_query($1, $$

SELECT * FROM util.diff(

  $$||quote_nullable($2)||$$

, $$||quote_nullable($3)||$$

, NULL::$$||$4||$$)

$$);

$_$;

--

-- Name: FUNCTION remake_diff_table(diff_table text, left_table regclass, right_table regclass, type_table text); Type: COMMENT; Schema: util; Owner: -

--

COMMENT ON FUNCTION remake_diff_table(diff_table text, left_table regclass, right_table regclass, type_table text) IS '

type_table (*required*): table to create as the shared base type

';

--