Project

General

Profile

« Previous | Next » 

Revision 14358

Added by Aaron Marcuse-Kubitza over 10 years ago

schemas/util.sql: remove_prefix(), remove_suffix(): support case-insensitive matching

View differences:

trunk/inputs/.TNRS/schema.sql
99 99 
CREATE FUNCTION remove_prefix(prefix text, str text, require boolean DEFAULT true, case_sensitive boolean DEFAULT true) RETURNS text
100 100 
    LANGUAGE sql IMMUTABLE
101 101 
    AS $$
102 
SELECT util.remove_prefix(prefix, str, require)
102 
SELECT util.remove_prefix(prefix, str, require, case_sensitive)
103 103 
$$;
104 104 

  		




  105
  105
  
    

  		












  

    
      trunk/schemas/vegbien.sql
    
  





  19718
  19718
  
    
CREATE FUNCTION remove_prefix(prefix text, str text, require boolean DEFAULT true, case_sensitive boolean DEFAULT true) RETURNS text


  		




  19719
  19719
  
    
    LANGUAGE sql IMMUTABLE


  		




  19720
  19720
  
    
    AS $$


  		




  19721
  
  
    
SELECT util.remove_prefix(prefix, str, require)


  		




  
  19721
  
    
SELECT util.remove_prefix(prefix, str, require, case_sensitive)


  		




  19722
  19722
  
    
$$;


  		




  19723
  19723
  
    

  		




  19724
  19724
  
    

  		












Also available in:  Unified diff