--le but de ce script est d'explorer la démographie sur le front pionnier, à partir des données extraites avec le script 4 declare @t; -- créer une table vide pour exporter les données demographiques CREATE TABLE "demoDensif" ( /*"Time" double precision, "Simulation"double precision, "Id"double precision, */ "05Living"double precision, "05dead"double precision, "05sent"double precision, "05received"double precision, "515Living"double precision, "515dead"double precision, "515sent"double precision, "515received"double precision, "1517Living"double precision, "1517dead"double precision, "1517sent"double precision, "1517received"double precision, "1725Living"double precision, "1725dead"double precision, "1725sent"double precision, "1725received"double precision, "25+Living"double precision, "25+dead"double precision, "60-Living"double precision, "60-dead"double precision, "60-sent"double precision, "60-received"double precision, "60+Living"double precision, "60+dead"double precision, "60+sent"double precision, "60+received"double precision ) WITH ( OIDS=FALSE ); --pour les 25 ans du front pionnier set @t = 1; while @t < 26 begin -- boucle pour exctraire les vivants, morts et adoptés totaux INSERT INTO public."demoFrontPionnier" SELECT /*pionnier@t."Time", pionnier@t."Simulation", pionnier@t."Id",*/ sum(pionnier@t."05Living"), sum(pionnier@t."05dead"), sum(pionnier@t."05sent"), sum(pionnier@t."05received"), sum(pionnier@t."515Living"), sum(pionnier@t."515dead"), sum(pionnier@t."515sent"), sum(pionnier@t."515received"), sum(pionnier@t."1517Living"), sum(pionnier@t."1517dead"), sum(pionnier@t."1517sent"), sum(pionnier@t."1517received"), sum(pionnier@t."1725Living"), sum(pionnier@t."1725dead"), sum(pionnier@t."1725sent"), sum(pionnier@t."1725received"), sum(pionnier@t."25+Living"), sum(pionnier@t."25+dead"), sum(pionnier@t."60-Living"), sum(pionnier@t."60-dead"), sum(pionnier@t."60-sent"), sum(pionnier@t."60-received"), sum(pionnier@t."60+Living"), sum(pionnier@t."60+dead"), sum(pionnier@t."60+sent"), sum(pionnier@t."60+received") FROM public.pionnier@t; set @t = @t + 1; end