Project

General

Profile

« Previous | Next » 

Revision 4501

Added by Aaron Marcuse-Kubitza about 12 years ago

schemas/functions.sql: _alt(): Added extra numbered parameters. Eventually these will need to be converted to variadic args, but this will require special support from column-based import.

View differences:

schemas/functions.sql
29 29 

  		




  30
  30
  
    

  		




  31
  31
  
    
--


  		




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


  		




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


  		




  33
  33
  
    
--


  		




  34
  34
  
    

  		




  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


  		




  
  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, "10" anyelement DEFAULT NULL::unknown, "11" anyelement DEFAULT NULL::unknown, "12" anyelement DEFAULT NULL::unknown) RETURNS anyelement


  		




  36
  36
  
    
    LANGUAGE sql IMMUTABLE


  		




  37
  37
  
    
    AS $_$


  		




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


  		




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


  		




  39
  39
  
    
$_$;


  		




  40
  40
  
    

  		




  41
  41
  
    

  		












Also available in:  Unified diff