Project

General

Profile

« Previous | Next » 

Revision 12289

Added by Aaron Marcuse-Kubitza almost 11 years ago

fix: schemas/util.sql: diff(regclass, regclass): renamed params to *_table because these actually can't be views, since views don't support inheritance

View differences:

util.sql
971 971 
-- Name: diff(regclass, regclass, anyelement); Type: FUNCTION; Schema: util; Owner: -
972 972 
--
973 973 

  		




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


  		




  
  974
  
    
CREATE FUNCTION diff(left_table regclass, right_table regclass, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement) RETURNS SETOF record


  		




  975
  975
  
    
    LANGUAGE sql STABLE


  		




  976
  976
  
    
    AS $_$


  		




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


  		




  ......




  979
  979
  
    

  		




  980
  980
  
    

  		




  981
  981
  
    
--


  		




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


  		




  
  982
  
    
-- Name: FUNCTION diff(left_table regclass, right_table regclass, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement); Type: COMMENT; Schema: util; Owner: -


  		




  983
  983
  
    
--


  		




  984
  984
  
    

  		




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


  		




  
  985
  
    
COMMENT ON FUNCTION diff(left_table regclass, right_table regclass, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement) IS '


  		




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


  		




  987
  987
  
    
usage:


  		




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


  		




  
  988
  
    
SELECT * FROM util.diff(''"left_table"'', ''"right_table"'', NULL::text)


  		




  989
  989
  
    
';


  		




  990
  990
  
    

  		




  991
  991
  
    

  		












Also available in:  Unified diff