Protect SVF normalizers against NULL values

[transitory.git] / Open-ILS / src / sql / Pg / 030.schema.metabib.sql

diff --git a/Open-ILS/src/sql/Pg/030.schema.metabib.sql b/Open-ILS/src/sql/Pg/030.schema.metabib.sql
index c815d88..0ea948e 100644 (file)
--- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql
+++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql
@@ -1052,7 +1052,7 @@ BEGIN
                       WHERE attr = attr_def.name
                       ORDER BY m.pos LOOP
                         EXECUTE 'SELECT ' || normalizer.func || '(' ||
-                            quote_literal( attr_value ) ||
+                            COALESCE( quote_literal( attr_value ), 'NULL' ) ||
                             CASE
                                 WHEN normalizer.param_count > 0
                                     THEN ',' || REPLACE(REPLACE(BTRIM(normalizer.params,'[]'),E'\'',E'\\\''),E'"',E'\'')