Project

General

Profile

« Previous | Next » 

Revision 12279

Added by Aaron Marcuse-Kubitza over 10 years ago

schemas/util.sql: diff_cols(): renamed to diff_queries() because multiple columns are supported

View differences:

trunk/schemas/util.sql
922 922 

  		




  923
  923
  
    

  		




  924
  924
  
    
--


  		




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


  		




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


  		




  926
  926
  
    
--


  		




  927
  927
  
    

  		




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


  		




  
  928
  
    
CREATE FUNCTION diff_queries(left_query text, right_query 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


  		




  ......




  946
  946
  
    

  		




  947
  947
  
    

  		




  948
  948
  
    
--


  		




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


  		




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


  		




  950
  950
  
    
--


  		




  951
  951
  
    

  		




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


  		




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


  		




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


  		




  954
  954
  
    
usage:


  		




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


  		




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


  		




  956
  956
  
    

  		




  957
  957
  
    
to run EXPLAIN on the FULL JOIN query:


  		




  958
  958
  
    
# run this function


  		




  ......




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


  		




  969
  969
  
    
    LANGUAGE sql STABLE


  		




  970
  970
  
    
    AS $_$


  		




  971
  
  
    
SELECT * FROM util.diff_cols($$SELECT * FROM $$||$1, $$SELECT * FROM $$||$2, $3)


  		




  
  971
  
    
SELECT * FROM util.diff_queries($$SELECT * FROM $$||$1, $$SELECT * FROM $$||$2, $3)


  		




  972
  972
  
    
$_$;


  		




  973
  973
  
    

  		




  974
  974
  
    

  		












Also available in:  Unified diff