 ref_nomenclatures.get_id_nomenclature('TYP_DENBR', 'NSP'),
 jeune AS count_min,
 jeune AS count_max
-FROM v1_compat.t_releves_cf cf
+FROM v1_compat.vm_t_releves_cf cf
 WHERE jeune > 0;
 
 INSERT INTO pr_occtax.cor_counting_occtax(

ref_nomenclatures.get_id_nomenclature('TYP_DENBR', 'NSP'),
yearling AS count_min,
yearling AS count_max
FROM v1_compat.t_releves_cf cf
WHERE yearling > 0;




-- mettre à jour le serial
SELECT pg_catalog.setval('pr_occtax.cor_counting_occtax_id_counting_occtax_seq', (SELECT max(id_counting_occtax)+1 FROM pr_occtax.cor_counting_occtax), true);

