如何在Postgress中获取给定月份的周范围

WITH first_day_of_month AS (
    SELECT DATE_TRUNC('month', CURRENT_DATE) AS first_day
),
first_week_start AS (
    SELECT
        CASE
            WHEN EXTRACT(DOW FROM first_day) = 0 THEN first_day + INTERVAL '1 day'
            ELSE first_day
        END AS week_start
    FROM first_day_of_month
),
month_weeks AS (
    SELECT
        generate_series(week_start, (week_start + INTERVAL '6 days'), INTERVAL '1 day') AS week_day
    FROM first_week_start
)
SELECT
    week_start,
    week_end
FROM (
    SELECT
        week_day - INTERVAL '1 day' AS week_start,
        week_day AS week_end
    FROM month_weeks
) subquery
WHERE week_start >= first_day AND week_end <= (first_day + INTERVAL '1 month' - INTERVAL '1 day')
ORDER BY week_start;