Project

General

Profile

« Previous | Next » 

Revision 13852

Added by Aaron Marcuse-Kubitza over 10 years ago

bugfix: inputs/.TNRS/schema.sql: taxon_name_is_safe(): need to use `NOT (_ = ANY()) instead of ` != ANY`, because the != operator is applied to each element

View differences:

trunk/inputs/.TNRS/schema.sql
99 99 
CREATE FUNCTION taxon_name_is_safe(taxon_name text) RETURNS boolean
100 100 
    LANGUAGE sql IMMUTABLE
101 101 
    AS $_$
102 
SELECT $1 != ANY("TNRS".unsafe_taxon_names())
102 
SELECT NOT ($1 = ANY("TNRS".unsafe_taxon_names()))
103 103 
$_$;
104 104 

  		




  105
  105
  
    

  		












  

    
      trunk/schemas/vegbien.sql
    
  





  19048
  19048
  
    
CREATE FUNCTION taxon_name_is_safe(taxon_name text) RETURNS boolean


  		




  19049
  19049
  
    
    LANGUAGE sql IMMUTABLE


  		




  19050
  19050
  
    
    AS $_$


  		




  19051
  
  
    
SELECT $1 != ANY("TNRS".unsafe_taxon_names())


  		




  
  19051
  
    
SELECT NOT ($1 = ANY("TNRS".unsafe_taxon_names()))


  		




  19052
  19052
  
    
$_$;


  		




  19053
  19053
  
    

  		




  19054
  19054
  
    

  		












Also available in:  Unified diff