Add a list of names to a generated series
0
votes
1
answer
281
views
I generated a date series this way:
SELECT generate_series(date '2020-01-01', date '2021-01-21', '1 day');
Additionally I have a list with name (Max Meyer, Anna Smith, Peter Gardner).
How could I add the name list to the date series, such that the name appears for every date in the series?
Asked by wladi
(1 rep)
Jul 2, 2021, 03:49 PM
Last activity: Jul 23, 2021, 08:46 AM
Last activity: Jul 23, 2021, 08:46 AM