Re: [Feature Request] Support INSERT ... FROM ... TO for date ranges

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)