Project

General

Profile

« Previous | Next » 

Revision 7292

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/.TNRS/schema.sql: Renamed tnrs_populate_accepted_scientific_name() trigger to tnrs_populate_derived_fields() to accommodate additional derived fields

View differences:

schema.sql
44 44 
  OIDS=FALSE
45 45 
);
46 46 

  		




  47
  
  
    
CREATE OR REPLACE FUNCTION tnrs_populate_accepted_scientific_name()


  		




  
  47
  
    
CREATE OR REPLACE FUNCTION tnrs_populate_derived_fields()


  		




  48
  48
  
    
  RETURNS trigger AS


  		




  49
  49
  
    
$BODY$


  		




  50
  50
  
    
BEGIN


  		




  ......




  60
  60
  
    
  LANGUAGE plpgsql VOLATILE


  		




  61
  61
  
    
  COST 100;


  		




  62
  62
  
    

  		




  63
  
  
    
CREATE TRIGGER tnrs_populate_accepted_scientific_name


  		




  
  63
  
    
CREATE TRIGGER tnrs_populate_derived_fields


  		




  64
  64
  
    
  BEFORE INSERT OR UPDATE


  		




  65
  65
  
    
  ON tnrs


  		




  66
  66
  
    
  FOR EACH ROW


  		




  67
  
  
    
  EXECUTE PROCEDURE tnrs_populate_accepted_scientific_name();


  		




  
  67
  
    
  EXECUTE PROCEDURE tnrs_populate_derived_fields();


  		




  68
  68
  
    

  		




  69
  69
  
    

  		




  70
  70
  
    
CREATE OR REPLACE VIEW "tnrs+accepted" AS


  		












Also available in:  Unified diff