generate_series

月末を取得して1～31までを作る。SELECT generate_series(1, EXTRACT(DAY FROM enddate)::INTEGER) AS date FROM ( SELECT DATE_TRUNC('month',...