Project

General

Profile

« Previous | Next » 

Revision 12427

Added by Aaron Marcuse-Kubitza almost 11 years ago

bugfix: schemas/util.sql: diff(*): changed from STABLE to VOLATILE because these functions create tables

View differences:

trunk/schemas/util.sql
1001 1001 
--
1002 1002 

  		




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


  		




  1004
  
  
    
    LANGUAGE sql STABLE


  		




  
  1004
  
    
    LANGUAGE sql


  		




  1005
  1005
  
    
    AS $_$


  		




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


  		




  1007
  1007
  
    
	util.has_single_row($1) AND util.has_single_row($2))


  		




  ......




  1024
  1024
  
    
--


  		




  1025
  1025
  
    

  		




  1026
  1026
  
    
CREATE FUNCTION diff(left_ text, right_ text, col_type_null anyelement, single_row boolean DEFAULT false, OUT left_ anyelement, OUT right_ anyelement) RETURNS SETOF record


  		




  1027
  
  
    
    LANGUAGE sql STABLE


  		




  
  1027
  
    
    LANGUAGE sql


  		




  1028
  1028
  
    
    SET search_path TO util


  		




  1029
  1029
  
    
    AS $_$


  		




  1030
  1030
  
    
SELECT * FROM


  		












Also available in:  Unified diff