[PostgreSQL] 테이블에 없는 날짜 조회하기

select 
	*
from my_table A
right join 
	(
		select generate_series('2024-01-01'::date, '2024-07-08'::date, '1 day'), 'YYYYMMDD' AS my_date
	) B 
on A.my_date = B.my_date
where A.my_date is null