On Tue, 31 Jul 2001, macky wrote:
> can someone point me to the documentation of RANDOM() function....
>
> and can i insert RANDOM POSTIVE WHOLE NUMBERS...?
>
> create table table_name (key int4);
>
> insert into table_name(key) values(random()); <-- this gives me a value of
> 1 and 0 only..
>
random produces a float between 0 and 1. Just multiple it with the
interval you want and you will get the random number you want.
eg. to get a random number between 0 and 100 -> 100 * random().
between 32 and 40 -> (8 * random()) + 32.
- Einar Karttunen