1 -- Evergreen DB patch 0662.schema.coded-value-map-index-normalizer.sql
5 -- check whether patch can be applied
6 SELECT evergreen.upgrade_deps_block_check('0662', :eg_version);
8 -- create the normalizer
9 CREATE OR REPLACE FUNCTION evergreen.coded_value_map_normalizer( input TEXT, ctype TEXT )
11 SELECT COALESCE(value,$1)
12 FROM config.coded_value_map
13 WHERE ctype = $2 AND code = $1;
16 -- register the normalizer
17 INSERT INTO config.index_normalizer (name, description, func, param_count) VALUES (
18 'Coded Value Map Normalizer',
19 'Applies coded_value_map mapping of values',
20 'coded_value_map_normalizer',