On 2025-Jul-17, zkbp712 wrote: > Alternative (optional) syntax idea: > > INSERT INTO dosage (medication_id, amount, date) > GENERATE RANGE (5, 3, '2025-04-01', '2025-04-30');
Here's a simple way to achieve this: INSERT INTO dosage(medication_id, amount, date) SELECT 5, 3, g FROM generate_series(date '2025-04-01', '2025-04-30', '1 day') AS g; No new features are needed. -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ "Nunca se desea ardientemente lo que solo se desea por razón" (F. Alexandre)
