Revision 12045
Added by Aaron Marcuse-Kubitza almost 11 years ago
util.sql | ||
---|---|---|
916 | 916 |
|
917 | 917 |
|
918 | 918 |
-- |
919 |
-- Name: diff_views(regclass, regclass, anyelement); Type: FUNCTION; Schema: util; Owner: - |
|
920 |
-- |
|
921 |
|
|
922 |
CREATE FUNCTION diff_views(left_view regclass, right_view regclass, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement) RETURNS SETOF record |
|
923 |
LANGUAGE sql STABLE |
|
924 |
AS $_$ |
|
925 |
SELECT * FROM util.diff_cols($$SELECT * FROM $$||$1, $$SELECT * FROM $$||$1, $3) |
|
926 |
$_$; |
|
927 |
|
|
928 |
|
|
929 |
-- |
|
930 |
-- Name: FUNCTION diff_views(left_view regclass, right_view regclass, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement); Type: COMMENT; Schema: util; Owner: - |
|
931 |
-- |
|
932 |
|
|
933 |
COMMENT ON FUNCTION diff_views(left_view regclass, right_view regclass, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement) IS 'col_type_null (*required*): NULL::col_type |
|
934 |
usage: |
|
935 |
SELECT * FROM util.diff_views(''"left_view"'', ''"right_view"'', NULL::text) |
|
936 |
'; |
|
937 |
|
|
938 |
|
|
939 |
-- |
|
919 | 940 |
-- Name: do_optionally_ignore(text, boolean); Type: FUNCTION; Schema: util; Owner: - |
920 | 941 |
-- |
921 | 942 |
|
Also available in: Unified diff
schemas/util.sql: added diff_views()