X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=sql%2Fbase%2F09-misc.sql;fp=sql%2Fbase%2F09-misc.sql;h=66faa4a336af8c0d60b026be33c59895502e4987;hp=e8c342a7359707349005cb55ac99fb5585adc951;hb=f0ee39dc063f53fdabdb105c2e89041ca299dc96;hpb=f609a846f806d93b317957e827c8cd26472a9f3f

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;