more SVF value normalizers, and application thereof

[evergreen-equinox.git] / Open-ILS / src / sql / Pg / 002.schema.config.sql

diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql
index 4de56e5..4d14a59 100644 (file)
--- a/Open-ILS/src/sql/Pg/002.schema.config.sql
+++ b/Open-ILS/src/sql/Pg/002.schema.config.sql
@@ -768,6 +768,10 @@ CREATE OR REPLACE FUNCTION public.approximate_high_date( TEXT ) RETURNS TEXT AS
         SELECT approximate_date( $1, '9');
 $func$ LANGUAGE SQL STRICT IMMUTABLE;
 
+CREATE OR REPLACE FUNCTION public.content_or_null( TEXT ) RETURNS TEXT AS $func$
+        SELECT CASE WHEN $1 ~ E'^\\s*$' THEN NULL ELSE $1 END
+$func$ LANGUAGE SQL STRICT IMMUTABLE;
+
 CREATE OR REPLACE FUNCTION public.integer_or_null( TEXT ) RETURNS TEXT AS $func$
         SELECT CASE WHEN $1 ~ E'^\\d+$' THEN $1 ELSE NULL END
 $func$ LANGUAGE SQL STRICT IMMUTABLE;