Re: [PATCH] Generate random dates/times in a specified range

Damien Clochard <damien@dalibo.info>

From: Damien Clochard <damien@dalibo.info>

To: Greg Sabino Mullane <htamfids@gmail.com>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, Dean Rasheed <dean.a.rasheed@gmail.com>, pgsql-hackers@lists.postgresql.org

Date: 2025-07-24T15:20:12Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

doc: Improve description of new random(min, max) functions.
- 9c24111c4dad 19 (unreleased) landed
Add date and timestamp variants of random(min, max).
- faf071b55383 19 (unreleased) landed

Attachments

v2-0001-Generate-random-dates-times-in-a-specified-range.patch (text/x-diff) patch v2-0001

Le 21.07.2025 21:06, Greg Sabino Mullane a écrit :
> Damien, maybe we can let the time ones go? Tom and I are not big fans
> of those, and nobody else has stepped up to defend them.
> 

Sure !

Here's a second version with the following changes

- remove time and timetz variants
- disallow infinity boundaries
- remove unnecessary int32 cast
- add examples in the documentation
- run pgindent
- update tests
- fix typos

Thanks for the feedback and insights

-- 
Damien Clochard