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;

select x, y, generate_series(-1,1) as x_g, value from test_mov_avg