Project

General

Profile

« Previous | Next » 

Revision 4150

Added by Aaron Marcuse-Kubitza over 12 years ago

schemas/functions.sql: Made aggregating functions polymorphic

View differences:

schemas/functions.sql
29 29 

  		




  30
  30
  
    

  		




  31
  31
  
    
--


  		




  32
  
  
    
-- Name: _alt(text, text, text, text, text, text, text, text, text, text); Type: FUNCTION; Schema: functions; Owner: -


  		




  
  32
  
    
-- Name: _alt(anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement); Type: FUNCTION; Schema: functions; Owner: -


  		




  33
  33
  
    
--


  		




  34
  34
  
    

  		




  35
  
  
    
CREATE FUNCTION _alt("0" text DEFAULT NULL::text, "1" text DEFAULT NULL::text, "2" text DEFAULT NULL::text, "3" text DEFAULT NULL::text, "4" text DEFAULT NULL::text, "5" text DEFAULT NULL::text, "6" text DEFAULT NULL::text, "7" text DEFAULT NULL::text, "8" text DEFAULT NULL::text, "9" text DEFAULT NULL::text) RETURNS text


  		




  
  35
  
    
CREATE FUNCTION _alt("0" anyelement DEFAULT NULL::unknown, "1" anyelement DEFAULT NULL::unknown, "2" anyelement DEFAULT NULL::unknown, "3" anyelement DEFAULT NULL::unknown, "4" anyelement DEFAULT NULL::unknown, "5" anyelement DEFAULT NULL::unknown, "6" anyelement DEFAULT NULL::unknown, "7" anyelement DEFAULT NULL::unknown, "8" anyelement DEFAULT NULL::unknown, "9" anyelement DEFAULT NULL::unknown) RETURNS anyelement


  		




  36
  36
  
    
    LANGUAGE sql IMMUTABLE


  		




  37
  37
  
    
    AS $_$


  		




  38
  38
  
    
SELECT coalesce($1, $2, $3, $4, $5, $6, $7, $8, $9, $10)


  		




  ......




  88
  88
  
    

  		




  89
  89
  
    

  		




  90
  90
  
    
--


  		




  91
  
  
    
-- Name: _merge(text, text, text, text, text, text, text, text, text, text); Type: FUNCTION; Schema: functions; Owner: -


  		




  
  91
  
    
-- Name: _merge(anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement); Type: FUNCTION; Schema: functions; Owner: -


  		




  92
  92
  
    
--


  		




  93
  93
  
    

  		




  94
  
  
    
CREATE FUNCTION _merge("0" text DEFAULT NULL::text, "1" text DEFAULT NULL::text, "2" text DEFAULT NULL::text, "3" text DEFAULT NULL::text, "4" text DEFAULT NULL::text, "5" text DEFAULT NULL::text, "6" text DEFAULT NULL::text, "7" text DEFAULT NULL::text, "8" text DEFAULT NULL::text, "9" text DEFAULT NULL::text) RETURNS text


  		




  
  94
  
    
CREATE FUNCTION _merge("0" anyelement DEFAULT NULL::unknown, "1" anyelement DEFAULT NULL::unknown, "2" anyelement DEFAULT NULL::unknown, "3" anyelement DEFAULT NULL::unknown, "4" anyelement DEFAULT NULL::unknown, "5" anyelement DEFAULT NULL::unknown, "6" anyelement DEFAULT NULL::unknown, "7" anyelement DEFAULT NULL::unknown, "8" anyelement DEFAULT NULL::unknown, "9" anyelement DEFAULT NULL::unknown) RETURNS anyelement


  		




  95
  95
  
    
    LANGUAGE sql IMMUTABLE


  		




  96
  96
  
    
    AS $_$


  		




  97
  97
  
    
SELECT functions.join_strs(value, '; ')


  		












Also available in:  Unified diff