Project

General

Profile

« Previous | Next » 

Revision 12045

schemas/util.sql: added diff_views()

View differences:

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