generate_series(0,14,7) : generate_series « Postgre SQL « PostgreSQL






  1. PostgreSQL
  2. Postgre SQL
  3. generate_series

generate_series(0,14,7)



postgres=# select current_date + s.a as dates from generate_series(0,14,7) as s(a);
   dates
------------
 2006-10-19
 2006-10-26
 2006-11-02
(3 rows)

postgres=#
postgres=#








Related examples in the same category

1.generate_series demo
2.generate_series(5,1,-2)
3.generate_series(4,3)