Project

General

Profile

« Previous | Next » 

Revision 10374

Added by Aaron Marcuse-Kubitza almost 11 years ago

schemas/util.sql: map_nulls(): use new nulls_map(). proper inlining (i.e. same runtime before and after change) has been verified with the following profiling query:
SELECT util.map_nulls(array[1, 2, 3]::text[], v) FROM unnest(array_fill(1, array100000)) f (v)

View differences:

util.sql
1186 1186 
CREATE FUNCTION map_nulls(nulls text[], value anyelement) RETURNS anyelement
1187 1187 
    LANGUAGE sql IMMUTABLE
1188 1188 
    AS $_$
1189 
SELECT util._map(util.hstore($1, NULL) || '*=>*', $2)
1189 
SELECT util._map(util.nulls_map($1), $2)
1190 1190 
$_$;
1191 1191 

  		




  1192
  1192
  
    

  		












Also available in:  Unified diff