Re: Joining with calendar table

2022-04-19 Thread Adrian Klaver
On 4/19/22 00:34, Pól Ua L. wrote: Bonjour a tous/Hello all, Small problem - I hope it not to trivial for here. We created a table, then someone deleted some records and we want to put them back, but we not sure how. CREATE TABLE dat AS   SELECT     GENERATE_SERIES     (       '2022-0

Joining with calendar table

2022-04-19 Thread Pól Ua L .
Bonjour a tous/Hello all, Small problem - I hope it not to trivial for here. We created a table, then someone deleted some records and we want to put them back, but we not sure how. CREATE TABLE dat AS SELECT GENERATE_SERIES ( '2022-03-01'::DATE, '2022-04-18'::DATE, '1 DAY' ) AS jour; So, all