Project

General

Profile

« Previous | Next » 

Revision 5401

Added by Aaron Marcuse-Kubitza about 12 years ago

schemas/vegbien.sql: _set_canon_taxonconcept(): Also set the canon_concept_fit_fraction

View differences:

vegbien.sql
250 250 

  		




  251
  251
  
    

  		




  252
  252
  
    
--


  		




  253
  
  
    
-- Name: _set_canon_taxonconcept(integer, integer); Type: FUNCTION; Schema: public; Owner: -


  		




  
  253
  
    
-- Name: _set_canon_taxonconcept(integer, integer, double precision); Type: FUNCTION; Schema: public; Owner: -


  		




  254
  254
  
    
--


  		




  255
  255
  
    

  		




  256
  
  
    
CREATE FUNCTION _set_canon_taxonconcept(taxonconcept_id integer, canon_concept_id integer) RETURNS integer


  		




  
  256
  
    
CREATE FUNCTION _set_canon_taxonconcept(taxonconcept_id integer, canon_concept_id integer, canon_concept_fit_fraction double precision DEFAULT NULL::double precision) RETURNS integer


  		




  257
  257
  
    
    LANGUAGE sql


  		




  258
  258
  
    
    AS $_$


  		




  259
  
  
    
UPDATE taxonconcept SET canon_concept_id = $2 WHERE taxonconcept_id = $1


  		




  
  259
  
    
UPDATE taxonconcept SET


  		




  
  260
  
    
  canon_concept_id = $2


  		




  
  261
  
    
, canon_concept_fit_fraction = $3


  		




  
  262
  
    
WHERE taxonconcept_id = $1


  		




  260
  263
  
    
RETURNING taxonconcept_id


  		




  261
  264
  
    
$_$;


  		




  262
  265
  
    

  		












Also available in:  Unified diff