Project

General

Profile

« Previous | Next » 

Revision 10328

schemas/util.sql: map_nulls(): support all datatypes, not just text

View differences:

schemas/util.sql
1115 1115

  
1116 1116

  
1117 1117
--
1118
-- Name: map_nulls(text[], text); Type: FUNCTION; Schema: util; Owner: -
1118
-- Name: map_nulls(anyarray, anyelement); Type: FUNCTION; Schema: util; Owner: -
1119 1119
--
1120 1120

  
1121
CREATE FUNCTION map_nulls(nulls text[], value text) RETURNS text
1121
CREATE FUNCTION map_nulls(nulls anyarray, value anyelement) RETURNS anyelement
1122 1122
    LANGUAGE sql IMMUTABLE STRICT
1123 1123
    SET search_path TO util
1124 1124
    AS $_$

Also available in: Unified diff