Contents
setseed()
A function for setting the random number generator seed
setseed()
is a system function for setting the random number generator seed used in subsequent calls to the random()
function.
setseed()
was added in PostgreSQL 7.0.
Usage
setseed ( double precision ) → void
The provided value must be in the range -1
to 1
.
Note that SET SEED TO double precision
is equivalent to calling this function.
Change history
- PostgreSQL 7.0
- added (commit a349733b)
Examples
Basic usage example for setseed()
:
postgres=# SELECT setseed(-0.1); setseed --------- (1 row)
Attempting to provide an invalue seed value:
postgres=# SELECT setseed(99); ERROR: setseed parameter 99 is out of allowed range [-1,1]
References
- PostgreSQL documentation: Random Functions