Project

General

Profile

« Previous | Next » 

Revision 12443

Added by Aaron Marcuse-Kubitza almost 11 years ago

schemas/util.sql: %==(anyelement, anyelement): needs to be declared STABLE instead of IMMUTABLE because it depends on the search_path (as described at http://vegpath.org/links/#PostgreSQL:%20Documentation:%209.3:%20Function%20Volatility%20Categories%20**)

View differences:

trunk/schemas/util.sql
76 76 
--
77 77 

  		




  78
  78
  
    
CREATE FUNCTION "%=="(left_ anyelement, right_ anyelement) RETURNS boolean


  		




  79
  
  
    
    LANGUAGE sql IMMUTABLE


  		




  
  79
  
    
    LANGUAGE sql STABLE


  		




  80
  80
  
    
    AS $_$


  		




  81
  81
  
    
SELECT keys($1) = keys($2)


  		




  82
  82
  
    
$_$;


  		




  83
  83
  
    

  		




  84
  84
  
    

  		




  85
  85
  
    
--


  		




  
  86
  
    
-- Name: FUNCTION "%=="(left_ anyelement, right_ anyelement); Type: COMMENT; Schema: util; Owner: -


  		




  
  87
  
    
--


  		




  
  88
  
    

  		




  
  89
  
    
COMMENT ON FUNCTION "%=="(left_ anyelement, right_ anyelement) IS '


  		




  
  90
  
    
needs to be declared STABLE instead of IMMUTABLE because it depends on the search_path (as described at http://vegpath.org/links/#PostgreSQL:%20Documentation:%209.3:%20Function%20Volatility%20Categories%20**)


  		




  
  91
  
    
';


  		




  
  92
  
    

  		




  
  93
  
    

  		




  
  94
  
    
--


  		




  86
  95
  
    
-- Name: _alt(anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement); Type: FUNCTION; Schema: util; Owner: -


  		




  87
  96
  
    
--


  		




  88
  97
  
    

  		












Also available in:  Unified diff