-- Name: diff_queries(text, text, anyelement); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION diff_queries(left_query text, right_query text, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement) RETURNS SETOF record

    LANGUAGE sql STABLE

    AS $_$

SELECT * FROM util.diff_any('('||$1||')', '('||$2||')', $3)

$_$;

--

-- Name: FUNCTION diff_queries(left_query text, right_query text, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement); Type: COMMENT; Schema: util; Owner: -

--

COMMENT ON FUNCTION diff_queries(left_query text, right_query text, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement) IS '

col_type_null (*required*): NULL::col_type

usage:

SELECT * FROM util.diff_queries($$VALUES (''1''), (''2''), (''4'')$$, $$VALUES (''1''), (''3''), (''4'')$$, NULL::text)

to run EXPLAIN on the FULL JOIN query:

# run this function

# look for a NOTICE containing the expanded query that it ran

# run EXPLAIN on this expanded query

';

--