Horton

Re: [PATCH] random_normal function

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David E. Wheeler" <david@justatheory.com>
Cc: Andrey Lepikhov <a.lepikhov@postgrespro.ru>, Dean Rasheed <dean.a.rasheed@gmail.com>, Fabien COELHO <coelho@cri.ensmp.fr>, Michael Paquier <michael@paquier.xyz>, Justin Pryzby <pryzby@telsasoft.com>, pgsql-hackers@postgresql.org, Paul Ramsey <pramsey@cleverelephant.ca>
Date: 2025-10-04T18:07:45Z
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. Round off random_normal() test results one more decimal place.

  2. Remove pg_regress' never-documented "ignore" feature.

  3. Upgrade the random.sql regression test.

  4. Invent random_normal() to provide normally-distributed random numbers.

I wrote:
> I didn't know about that page, but I'm happy to go remove its
> mention of "ignore:" ...

Actually, there is a *ton* of obsolete information on that page:
there's no serial_schedule file anymore, and we don't have
dynamically-generated test files anymore (input/output subdirectories)
and therefore there's no substituted variables.  The age of the whole
thing can be dated by its references to CVS :-(

Maybe we should indeed try to replace it with something in the main
docs, which are a bit more likely to get maintained.  There is an
existing chapter "Regression Tests", but it presently only talks
about how to run the tests not how to write new ones.

			regards, tom lane