Project

General

Profile

« Previous | Next » 

Revision 4683

Added by Aaron Marcuse-Kubitza over 12 years ago

schemas/functions.sql: _label(): Accept params of any type, in order to support types other than text (which come from staging tables that are imported directly from a SQL export). This fixes a bug in SALVIAS.plotMetadata's column-based import.

View differences:

schemas/functions.sql
84 84 

  		




  85
  85
  
    

  		




  86
  86
  
    
--


  		




  87
  
  
    
-- Name: _label(text, text); Type: FUNCTION; Schema: functions; Owner: -


  		




  
  87
  
    
-- Name: _label(anyelement, anyelement); Type: FUNCTION; Schema: functions; Owner: -


  		




  88
  88
  
    
--


  		




  89
  89
  
    

  		




  90
  
  
    
CREATE FUNCTION _label(label text, value text) RETURNS text


  		




  
  90
  
    
CREATE FUNCTION _label(label anyelement, value anyelement) RETURNS anyelement


  		




  91
  91
  
    
    LANGUAGE sql IMMUTABLE


  		




  92
  92
  
    
    AS $_$


  		




  93
  93
  
    
SELECT coalesce($1 || ': ', '') || $2


  		












Also available in:  Unified diff