Project

General

Profile

« Previous | Next » 

Revision 6091

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/vegbien.sql: reference_by_shortname(): Fixed bug where need to use $-syntax to reference params in sql-language functions

View differences:

vegbien.sql
763 763 

  		




  764
  764
  
    
CREATE FUNCTION reference_by_shortname(shortname text) RETURNS integer


  		




  765
  765
  
    
    LANGUAGE sql STABLE STRICT


  		




  766
  
  
    
    AS $$


  		




  767
  
  
    
SELECT reference_id FROM reference WHERE reference.shortname = shortname LIMIT 1


  		




  768
  
  
    
$$;


  		




  
  766
  
    
    AS $_$


  		




  
  767
  
    
SELECT reference_id FROM reference WHERE shortname = $1 LIMIT 1


  		




  
  768
  
    
$_$;


  		




  769
  769
  
    

  		




  770
  770
  
    

  		




  771
  771
  
    
--


  		












Also available in:  Unified diff