Fórum Preencher Lacuna (GAP) em coluna de tabela PostgreSQL #593106

--DROP FUNCTION fnc_int_intervalo(VARCHAR, VARCHAR);
CREATE OR REPLACE FUNCTION fnc_int_intervalo(tabela VARCHAR, campo VARCHAR)
  RETURNS integer AS
$BODY$
DECLARE
  intRetorno INTEGER DEFAULT 0;
  curSQL REFCURSOR;
  recSQL RECORD;
BEGIN

    OPEN curSQL FOR EXECUTE ''SELECT COALESCE(''|| Campo ||'',0) AS int_cod_atual FROM ''|| Tabela || '' ORDER BY ''|| Campo;
    LOOP
       FETCH curSQL INTO recSQL;
       intRetorno = intRetorno + 1;

       IF (intRetorno <> recSQL.int_cod_atual) OR (recSQL.int_cod_atual IS NULL) THEN
          RETURN intRetorno;
          CLOSE curSQL;
          EXIT;
       END IF;
    
    END LOOP;
    CLOSE curSQL;
 
  RETURN intRetorno;
END;
$BODY$
LANGUAGE ''plpgsql'' VOLATILE