Project

General

Profile

« Previous | Next » 

Revision 2554

Added by Aaron Marcuse-Kubitza about 12 years ago

schemas/vegbien.sql, functions.sql: Made cast functions STRICT to enable the RETURNS NULL ON NULL INPUT optimization

View differences:

functions.sql
23 23 
--
24 24 

  		




  25
  25
  
    
CREATE FUNCTION "boolean"(value text) RETURNS boolean


  		




  26
  
  
    
    LANGUAGE plpgsql IMMUTABLE


  		




  
  26
  
    
    LANGUAGE plpgsql IMMUTABLE STRICT


  		




  27
  27
  
    
    AS $$


  		




  28
  28
  
    
BEGIN


  		




  29
  29
  
    
    BEGIN


  		




  ......




  43
  43
  
    
--


  		




  44
  44
  
    

  		




  45
  45
  
    
CREATE FUNCTION "double precision"(value text) RETURNS double precision


  		




  46
  
  
    
    LANGUAGE plpgsql IMMUTABLE


  		




  
  46
  
    
    LANGUAGE plpgsql IMMUTABLE STRICT


  		




  47
  47
  
    
    AS $$


  		




  48
  48
  
    
BEGIN


  		




  49
  49
  
    
    BEGIN


  		




  ......




  63
  63
  
    
--


  		




  64
  64
  
    

  		




  65
  65
  
    
CREATE FUNCTION "timestamp with time zone"(value text) RETURNS timestamp with time zone


  		




  66
  
  
    
    LANGUAGE plpgsql IMMUTABLE


  		




  
  66
  
    
    LANGUAGE plpgsql IMMUTABLE STRICT


  		




  67
  67
  
    
    AS $$


  		




  68
  68
  
    
BEGIN


  		




  69
  69
  
    
    BEGIN


  		












Also available in:  Unified diff