- Categories:
UNIFORM¶
Returns a uniformly random number, in the inclusive range [min
, max
].
Syntax¶
UNIFORM( <min> , <max> , <gen> )
Usage Notes¶
min
andmax
must be constants.If
min
ormax
, or both, are floating point numbers, the generated numbers are floating point. If bothmin
andmax
are integers, the generated numbers are integers as well.gen
specifies the generator expression for the function. For more information, see Usage Notes.
Examples¶
SELECT uniform(1, 10, random()) FROM table(generator(rowCount => 5));
--------------------------+
uniform(1, 10, random()) |
--------------------------+
6 |
4 |
7 |
9 |
4 |
--------------------------+
SELECT uniform(0::float, 1::float, random()) FROM table(generator(rowCount => 5));
---------------------------------------+
uniform(0::float, 1::float, random()) |
---------------------------------------+
0.2895427479 |
0.7178660941 |
0.6925603163 |
0.05914526824 |
0.8243151404 |
---------------------------------------+
SELECT uniform(1, 10, 1234) FROM table(generator(rowCount => 5));
----------------------+
uniform(1, 10, 1234) |
----------------------+
7 |
7 |
7 |
7 |
7 |
----------------------+