如何在postgresql中使用lead函数组合日期

我用的是 generate_series 函数提取 start_date 和 end_date 我试着用 daterange . 我写了这个问题:

     with a as(
select d.day::date as day from (select * from generate_series('2018-08-22'::timestamp, '2019-07-12'::timestamp, 
concat(greatest(date_part('days','2019-07-12'::timestamp - '2018-08-22'::timestamp)/8,1), ' day')::interval)) as d(day))
select daterange(day,(lead(day) over (order by day) - interval '1 day')::date,'[]')
FROM a

我得到了这些结果:

"[2018-08-22,2018-10-01)"
"[2018-10-01,2018-11-11)"
"[2018-11-11,2018-12-21)"
"[2018-12-21,2019-01-31)"
"[2019-01-31,2019-03-12)"
"[2019-03-12,2019-04-22)"
"[2019-04-22,2019-06-01)"
"[2019-06-01,2019-07-12)"
"[2019-07-12,)"

我不想显示最后一行 "[2019-07-12,)" . 如何管理查询以不显示包含 Infinity 价值。