Project

General

Profile

« Previous | Next » 

Revision 9989

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/.TNRS/schema.sql: tnrs_populate_fields(): updated runtime (16 min)

View differences:

schema.sql
83 83 

  		




  84
  84
  
    
/* IMPORTANT: when changing this function, you must regenerate the derived cols:


  		




  85
  85
  
    
UPDATE "TNRS".tnrs SET "Name_submitted" = "Name_submitted"


  		




  86
  
  
    
runtime: 16 min ("5220212 rows affected, 934611 ms execution time")


  		




  
  86
  
    
runtime: 16 min ("5220212 rows affected, 979511 ms execution time")


  		




  87
  87
  
    
*/


  		




  88
  88
  
    
CREATE OR REPLACE FUNCTION tnrs_populate_fields()


  		




  89
  89
  
    
  RETURNS trigger AS


  		












Also available in:  Unified diff