Project

General

Profile

« Previous | Next » 

Revision 9512

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/.TNRS/schema.sql: tnrs_populate_derived_fields(): renamed to tnrs_populate_fields() so it can be used to populate other fields as well

View differences:

schema.sql
59 59 
  ("Name_submitted" )
60 60 
  WHERE score_ok("Max_score");
61 61 

  		




  62
  
  
    
CREATE OR REPLACE FUNCTION tnrs_populate_derived_fields()


  		




  
  62
  
    
CREATE OR REPLACE FUNCTION tnrs_populate_fields()


  		




  63
  63
  
    
  RETURNS trigger AS


  		




  64
  64
  
    
$BODY$


  		




  65
  65
  
    
BEGIN


  		




  ......




  81
  81
  
    
  LANGUAGE plpgsql VOLATILE


  		




  82
  82
  
    
  COST 100;


  		




  83
  83
  
    

  		




  84
  
  
    
CREATE TRIGGER tnrs_populate_derived_fields


  		




  
  84
  
    
CREATE TRIGGER tnrs_populate_fields


  		




  85
  85
  
    
  BEFORE INSERT OR UPDATE


  		




  86
  86
  
    
  ON tnrs


  		




  87
  87
  
    
  FOR EACH ROW


  		




  88
  
  
    
  EXECUTE PROCEDURE tnrs_populate_derived_fields();


  		




  
  88
  
    
  EXECUTE PROCEDURE tnrs_populate_fields();


  		




  89
  89
  
    

  		




  90
  90
  
    

  		




  91
  91
  
    
CREATE OR REPLACE VIEW "MatchedTaxon" AS


  		












Also available in:  Unified diff