Re: RANDOM function?

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