Waiting for PostgreSQL 19 – Add date and timestamp variants of random(min, max). – select * from depesz;

PostgreSQL 19 introduces new random() function variants for generating random dates and timestamps within specified ranges. The update adds three new functions: random(min date, max date), random(min timestamp, max timestamp), and random(min timestamptz, max timestamptz). These functions simplify test data generation by eliminating the need for manual calculations with intervals and mathematical operations.