PostgreSQL的generate_series()函数的用法说明

我就废话不多说了，大家还是直接看代码吧~

SELECT generate_series(1,12) AS month;
SELECT generate_series(1,12,1) AS month;
SELECT generate_series(‘2020-01-01′::DATE,‘2020-12-31′::DATE,‘1 month’::INTERVAL) AS first_of_month;