One more example of generating time series

Started by PG Bug reporting formover 5 years ago1 messagesdocs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/13/functions-srf.html
Description:

I find this kind of query very useful:

If you don't know the end date, but you know how many time steps to add, you
can use a query like this
select now()+ '1 day'::interval *generate_series(1,5);