Project

General

Profile

« Previous | Next » 

Revision 9986

Added by Aaron Marcuse-Kubitza over 11 years ago

bugfix: inputs/.TNRS/schema.sql: family_is_homonym(), genus_is_homonym(): need to return NULL instead of false when input family/genus is NULL. EXISTS does not support this, so STRICT is used to provide this functionality automatically.

View differences:

inputs/.TNRS/schema.sql
11 11 
$BODY$
12 12 
SELECT EXISTS(SELECT * FROM "IRMNG".family_homonym_epithet WHERE "taxonNameOrEpithet" = $1)
13 13 
$BODY$
14 
  LANGUAGE sql STABLE
14 
  LANGUAGE sql STABLE STRICT
15 15 
  COST 100;
16 16 

  		




  17
  17
  
    
CREATE OR REPLACE FUNCTION genus_is_homonym(genus text)


  		




  ......




  19
  19
  
    
$BODY$


  		




  20
  20
  
    
SELECT EXISTS(SELECT * FROM "IRMNG".genus_homonym_epithet WHERE "taxonNameOrEpithet" = $1)


  		




  21
  21
  
    
$BODY$


  		




  22
  
  
    
  LANGUAGE sql STABLE


  		




  
  22
  
    
  LANGUAGE sql STABLE STRICT


  		




  23
  23
  
    
  COST 100;


  		




  24
  24
  
    

  		




  25
  25
  
    
/* IMPORTANT: when changing this table's schema, you must regenerate data.sql:


  		












Also available in:  Unified diff