PostgreSQL: Select a Random Number in a Range (Between Two Numbers) - Comment Page: 1
This is quick tip howto select a random number in a range. Example random number between 1-100 (>= 1 and < 100). This is actually very easy job with PostgreSQL own random() function, which returns random value between 0-1. Following example selects 5 random values using generate_series() function:
SELECT random() FROM generate_series(1,5);
random
-------------------
...
2 Comments
Valerie
Really helpful…Thanks! :)
vipin raj
Nice one!
But why MAX is 999 while MIN is 100, that is the range is [100, 999)
You can make it inclusive [100, 1000] by using
select max(trunc((100 + random()* (700-99)))) from generate_series(1, 100000);
generally
select max(trunc((start + random()* (end- (start – 1))))) from generate_series(1, 100000);