-- Name: mk_diff_query(text, text, boolean); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION mk_diff_query(left_ text, right_ text, single_row boolean DEFAULT false) RETURNS text

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT

$$SELECT left_, right_

FROM $$||$1||$$ left_

$$||util._if($3, 'CROSS'::text, 'FULL')||$$ JOIN $$||$2||$$ right_

$$||util._if($3, ''::text,

$$ON left_ %== right_ -- refer to EXPLAIN output for expansion of %==

$$)||

$$WHERE left_ IS DISTINCT FROM right_

ORDER BY left_, right_

$$

$_$;

--

-- Name: FUNCTION mk_diff_query(left_ text, right_ text, single_row boolean); Type: COMMENT; Schema: util; Owner: -

--

COMMENT ON FUNCTION mk_diff_query(left_ text, right_ text, single_row boolean) IS '

single_row: whether the tables consist of a single row, which should be

	displayed side-by-side

';

--