making the null out columns functions able to handle the term NULL and a single space...

[migration-tools.git] / sql / base / 09-misc.sql

diff --git a/sql/base/09-misc.sql b/sql/base/09-misc.sql
index e8c342a..66faa4a 100644 (file)
--- 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;