Project

General

Profile

« Previous | Next » 

Revision 12283

Added by Aaron Marcuse-Kubitza over 10 years ago

schemas/util.sql: renamed diff_views(), diff_any() to diff(...) because they are overloads of the same operation

View differences:

util.sql
922 922 

  		




  923
  923
  
    

  		




  924
  924
  
    
--


  		




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


  		




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


  		




  926
  926
  
    
--


  		




  927
  927
  
    

  		




  928
  
  
    
CREATE FUNCTION diff_any(left_ text, right_ text, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement) RETURNS SETOF record


  		




  
  928
  
    
CREATE FUNCTION diff(left_ text, right_ text, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement) RETURNS SETOF record


  		




  929
  929
  
    
    LANGUAGE sql STABLE


  		




  930
  930
  
    
    AS $_$


  		




  931
  931
  
    
SELECT * FROM


  		




  ......




  941
  941
  
    

  		




  942
  942
  
    

  		




  943
  943
  
    
--


  		




  944
  
  
    
-- Name: FUNCTION diff_any(left_ text, right_ text, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement); Type: COMMENT; Schema: util; Owner: -


  		




  
  944
  
    
-- Name: FUNCTION diff(left_ text, right_ text, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement); Type: COMMENT; Schema: util; Owner: -


  		




  945
  945
  
    
--


  		




  946
  946
  
    

  		




  947
  
  
    
COMMENT ON FUNCTION diff_any(left_ text, right_ text, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement) IS '


  		




  
  947
  
    
COMMENT ON FUNCTION diff(left_ text, right_ text, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement) IS '


  		




  948
  948
  
    
col_type_null (*required*): NULL::col_type


  		




  949
  949
  
    

  		




  950
  950
  
    
to run EXPLAIN on the FULL JOIN query:


  		




  ......




  955
  955
  
    

  		




  956
  956
  
    

  		




  957
  957
  
    
--


  		




  958
  
  
    
-- Name: diff_views(regclass, regclass, anyelement); Type: FUNCTION; Schema: util; Owner: -


  		




  
  958
  
    
-- Name: diff(regclass, regclass, anyelement); Type: FUNCTION; Schema: util; Owner: -


  		




  959
  959
  
    
--


  		




  960
  960
  
    

  		




  961
  
  
    
CREATE FUNCTION diff_views(left_view regclass, right_view regclass, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement) RETURNS SETOF record


  		




  
  961
  
    
CREATE FUNCTION diff(left_view regclass, right_view regclass, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement) RETURNS SETOF record


  		




  962
  962
  
    
    LANGUAGE sql STABLE


  		




  963
  963
  
    
    AS $_$


  		




  964
  
  
    
SELECT * FROM util.diff_any($1::text, $2::text, $3)


  		




  
  964
  
    
SELECT * FROM util.diff($1::text, $2::text, $3)


  		




  965
  965
  
    
$_$;


  		




  966
  966
  
    

  		




  967
  967
  
    

  		




  968
  968
  
    
--


  		




  969
  
  
    
-- 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: -


  		




  
  969
  
    
-- Name: FUNCTION diff(left_view regclass, right_view regclass, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement); Type: COMMENT; Schema: util; Owner: -


  		




  970
  970
  
    
--


  		




  971
  971
  
    

  		




  972
  
  
    
COMMENT ON FUNCTION diff_views(left_view regclass, right_view regclass, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement) IS '


  		




  
  972
  
    
COMMENT ON FUNCTION diff(left_view regclass, right_view regclass, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement) IS '


  		




  973
  973
  
    
col_type_null (*required*): NULL::col_type


  		




  974
  974
  
    
usage:


  		




  975
  
  
    
SELECT * FROM util.diff_views(''"left_view"'', ''"right_view"'', NULL::text)


  		




  
  975
  
    
SELECT * FROM util.diff(''"left_view"'', ''"right_view"'', NULL::text)


  		




  976
  976
  
    
';


  		




  977
  977
  
    

  		




  978
  978
  
    

  		












Also available in:  Unified diff