Project

General

Profile

« Previous | Next » 

Revision 7844

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/.TNRS/schema.sql: Added back score_ok() and tnrs.tnrs_score_ok index

View differences:

inputs/.TNRS/schema.sql
1 
CREATE OR REPLACE FUNCTION score_ok(score double precision)
2 
  RETURNS boolean AS
3 
$BODY$
4 
SELECT $1 >= 0.8
5 
$BODY$
6 
  LANGUAGE sql VOLATILE
7 
  COST 100;
8 

  		




  
  9
  
    

  		




  1
  10
  
    
CREATE TABLE tnrs


  		




  2
  11
  
    
(


  		




  3
  12
  
    
  "Time_submitted" timestamp with time zone,


  		




  ......




  45
  54
  
    
  OIDS=FALSE


  		




  46
  55
  
    
);


  		




  47
  56
  
    

  		




  
  57
  
    
CREATE UNIQUE INDEX tnrs_score_ok


  		




  
  58
  
    
  ON tnrs


  		




  
  59
  
    
  USING btree


  		




  
  60
  
    
  ("Name_submitted" )


  		




  
  61
  
    
  WHERE score_ok("Max_score");


  		




  
  62
  
    

  		




  48
  63
  
    
CREATE OR REPLACE FUNCTION tnrs_populate_derived_fields()


  		




  49
  64
  
    
  RETURNS trigger AS


  		




  50
  65
  
    
$BODY$


  		












Also available in:  Unified diff