How to use set-returning functions in PostgreSQL to generate simple timeseries data

A relatively simple but common application of time series done with PG.