create table if not exists vuln(id serial, discovered_on timestamptz, patched_by timestamptz, message text, source_id bigint);

insert into vuln(discovered_on, patched_by, message, source_id)  values(now() - '1 month'::interval, null, '1', 1);
insert into vuln(discovered_on, patched_by, message, source_id)  values(now() - '1 month'::interval, null, '2', 1000);
insert into vuln(discovered_on, patched_by, message, source_id)  values(now() - '3 month'::interval, now() - '2 month'::interval, '3', 1000);
insert into vuln(discovered_on, patched_by, message, source_id)  values(now() - '2 month'::interval, null, '1', 1);
insert into vuln(discovered_on, patched_by, message, source_id)  values(now() - '3 month'::interval, null, '1', 1);
insert into vuln(discovered_on, patched_by, message, source_id)  values(now() - '4 month'::interval, null, '1', 1);
insert into vuln(discovered_on, patched_by, message, source_id)  values(now() - '5 month'::interval, null, '1', 1);



select message,
       source_id,
       generate_series(date_trunc('month', discovered_on), least(date_trunc('month', discovered_on), now()), '1 month'::interval)

from vuln
where source_id >= 1000;