02_aud_nua.sql - ERROR: COALESCE types text and integer cannot be matched

SIU-Guaraní Migración de Datos
2

Debes reemplazar:

   INSERT INTO _TempNUA (nua) SELECT COALESCE(MAX(nua),1) FROM sga_actas;
   INSERT INTO _TempNUA (nua) SELECT COALESCE(MAX(nua),1) FROM sga_equiv_tramite;

por:

   INSERT INTO _TempNUA (nua) SELECT COALESCE(MAX(nua::integer),1) FROM sga_actas;
   INSERT INTO _TempNUA (nua) SELECT COALESCE(MAX(nua::integer),1) FROM sga_equiv_tramite;

02_aud_nua.sql (1.2 KB)