[PATCH] random_normal function

Paul Ramsey <pramsey@cleverelephant.ca>

From: Paul Ramsey <pramsey@cleverelephant.ca>

To: Pgsql Hackers <pgsql-hackers@postgresql.org>

Date: 2022-12-08T21:53:23Z

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 →

Round off random_normal() test results one more decimal place.
- 02d552c4f422 16.0 landed
Remove pg_regress' never-documented "ignore" feature.
- bd8d453e9b5f 16.0 landed
Upgrade the random.sql regression test.
- 09d517773f60 16.0 landed
Invent random_normal() to provide normally-distributed random numbers.
- 38d81760c4d7 16.0 landed

Attachments

random_normal_01.patch (application/octet-stream) patch

Just a utility function to generate random numbers from a normal
distribution. I find myself doing this several times a year, and I am
sure I must not be the only one.

random_normal(stddev float8 DEFAULT 1.0, mean float8 DEFAULT 0.0)