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

2025-07-17 Thread Álvaro Herrera
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_seri

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

2025-07-17 Thread zkbp712
Dear MySQL/PostgreSQL Development Teams, My nameis T-RegExr (Tyrannosaurus RegExr), and I am a developer working extensively withtime-series data such as medication dosages and other daily records. I would liketo propose a feature enhancement to simplify the insertion of multiple rowsover a co