Sample Header Ad - 728x90

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