Le portail francophone de la géomatique

ERROR : Invalid input syntax for integer : "31/0"

 WITH RECURSIVE t(code_depart, code_arrivee, date_eff, nb_boucles) AS (
                 SELECT sub_dreal_logement.code_commune::character(5) AS code_commune, sub_dreal_logement.code_commune::character(5) AS code_commune, 2006 AS date_eff, 1
                   FROM bdd_territoires.sub_dreal_logement
        UNION 
                 SELECT t.code_depart, r.com_ap, "left"(r.date_eff::text, 4)::integer AS "left", t.nb_boucles + 1
                   FROM listes_fonctionnelles.ref_mouvements_communes r
              JOIN t ON t.code_arrivee = r.com_av
             WHERE "left"(r.date_eff::text, 4)::integer > t.date_eff
        ), tc AS (
         SELECT t.code_depart, max(t.nb_boucles) AS nb_boucles
           FROM t
          GROUP BY t.code_depart
          ORDER BY t.code_depart
        ), table_sortie AS (
         SELECT DISTINCT t.code_depart, t.code_arrivee
           FROM t
      JOIN tc ON t.code_depart = tc.code_depart AND t.nb_boucles = tc.nb_boucles
     ORDER BY t.code_arrivee
        )
 SELECT ts.code_arrivee AS code_commune, t2.lib_commune, t1.nb_permis_construire, t1.nb_permis_amenager, t1.nb_declaration_prealable, t1.nb_permis_demolir, t1.annee_obs, t1.territoire
   FROM table_sortie ts
   LEFT JOIN bdd_territoires.sub_dreal_logement t1 ON t1.code_commune::bpchar = ts.code_depart
   LEFT JOIN listes_fonctionnelles.ref_echelle_geographique t2 ON ts.code_arrivee = t2.code_commune
  WHERE t2.code_region = '27'::bpchar;