Invent random_normal() to provide normally-distributed random numbers.
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 9 Jan 2023 17:44:00 +0000 (12:44 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 9 Jan 2023 17:44:00 +0000 (12:44 -0500)
commit38d81760c4d7e22b95252e3545596602c9e38806
treec5f8802619bf418dbdcc40392bb6d47123861908
parent2673ebf49acfd83b09c777ced8f21eacd27b51ce
Invent random_normal() to provide normally-distributed random numbers.

There is already a version of this in contrib/tablefunc, but it
seems sufficiently widely useful to justify having it in core.

Paul Ramsey

Discussion: https://postgr.es/m/CACowWR0DqHAvOKUCNxTrASFkWsDLqKMd6WiXvVvaWg4pV1BMnQ@mail.gmail.com
doc/src/sgml/func.sgml
src/backend/catalog/system_functions.sql
src/backend/utils/adt/float.c
src/bin/pgbench/pgbench.c
src/common/pg_prng.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.dat
src/include/common/pg_prng.h
src/test/regress/expected/random.out
src/test/regress/sql/random.sql