Horton

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

Damien Clochard <damien@dalibo.info>

View thread
From: Damien Clochard <damien@dalibo.info>
To: Vik Fearing <vik@postgresfriends.org>
Cc: Greg Sabino Mullane <htamfids@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, Dean Rasheed <dean.a.rasheed@gmail.com>, pgsql-hackers@lists.postgresql.org
Date: 2025-08-25T11:42:35Z
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 →

  1. doc: Improve description of new random(min, max) functions.

  2. Add date and timestamp variants of random(min, max).

Le 24.07.2025 20:24, Vik Fearing a écrit :
>> [...]
> 
> Just a small cosmetic gripe, the regression test comments are usually
> "-- ok" and "--fail", and not "--  Should error".
> 

Thanks Vik!

Here's a third version with the following changes:

* Rebase from master
* Replace 'Should error' by 'fail' in the test file
* move documentation from func.sgml to func/func-datetime.sgml

Note that former random function variants are documented in 
func/func-math.sgml but it felt more logical to document the new 
variants in func-datetime.sgml. As a result the random variants would be 
documented in 2 separate sections of chapter 9.

-- 
Damien Clochard