aboutsummaryrefslogtreecommitdiff
path: root/src/backend/utils/misc/guc_tables.c
diff options
context:
space:
mode:
authorDean Rasheed <dean.a.rasheed@gmail.com>2024-03-27 10:12:39 +0000
committerDean Rasheed <dean.a.rasheed@gmail.com>2024-03-27 10:12:39 +0000
commite6341323a8da64b18e9af3e75a4578230702d61c (patch)
treef04f8e7fa84af4b569e58c85d2a7d98f65f45303 /src/backend/utils/misc/guc_tables.c
parent818861eb578663a0d4d8d7dc4e18c96a148b3c75 (diff)
downloadpostgresql-e6341323a8da64b18e9af3e75a4578230702d61c.tar.gz
postgresql-e6341323a8da64b18e9af3e75a4578230702d61c.zip
Add functions to generate random numbers in a specified range.
This adds 3 new variants of the random() function: random(min integer, max integer) returns integer random(min bigint, max bigint) returns bigint random(min numeric, max numeric) returns numeric Each returns a random number x in the range min <= x <= max. For the numeric function, the number of digits after the decimal point is equal to the number of digits that "min" or "max" has after the decimal point, whichever has more. The main entry points for these functions are in a new C source file. The existing random(), random_normal(), and setseed() functions are moved there too, so that they can all share the same PRNG state, which is kept private to that file. Dean Rasheed, reviewed by Jian He, David Zhang, Aleksander Alekseev, and Tomas Vondra. Discussion: https://postgr.es/m/CAEZATCV89Vxuq93xQdmc0t-0Y2zeeNQTdsjbmV7dyFBPykbV4Q@mail.gmail.com
Diffstat (limited to 'src/backend/utils/misc/guc_tables.c')
0 files changed, 0 insertions, 0 deletions