From f0ee39dc063f53fdabdb105c2e89041ca299dc96 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Tue, 14 Jul 2020 09:34:39 -0400 Subject: [PATCH] making the null out columns functions able to handle the term NULL and a single space in case they haven't been trimmed --- sql/base/09-misc.sql | 4 ++++ 1 files changed, 4 insertions(+), 0 deletions(-) diff --git a/sql/base/09-misc.sql b/sql/base/09-misc.sql index e8c342a..66faa4a 100644 --- a/sql/base/09-misc.sql +++ b/sql/base/09-misc.sql @@ -61,6 +61,8 @@ BEGIN AND column_name like 'l_%' LOOP EXECUTE FORMAT('UPDATE ' || s_name || '.' || t_name || ' SET ' || c_name || ' = NULL WHERE ' || c_name || ' = '''' '); + EXECUTE FORMAT('UPDATE ' || s_name || '.' || t_name || ' SET ' || c_name || ' = NULL WHERE ' || c_name || ' = '' '' '); + EXECUTE FORMAT('UPDATE ' || s_name || '.' || t_name || ' SET ' || c_name || ' = NULL WHERE ' || c_name || ' = ''NULL'' '); END LOOP; RETURN TRUE; @@ -81,6 +83,8 @@ BEGIN AND (data_type='text' OR data_type='character varying') LOOP EXECUTE FORMAT('UPDATE ' || s_name || '.' || t_name || ' SET ' || c_name || ' = NULL WHERE ' || c_name || ' = '''' '); + EXECUTE FORMAT('UPDATE ' || s_name || '.' || t_name || ' SET ' || c_name || ' = NULL WHERE ' || c_name || ' = '' '' '); + EXECUTE FORMAT('UPDATE ' || s_name || '.' || t_name || ' SET ' || c_name || ' = NULL WHERE ' || c_name || ' = ''NULL'' '); END LOOP; RETURN TRUE; -- 1.7.2.5