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
In response to
pgsql-novice by date
|Next:||From: macky||Date: 2001-07-31 05:55:28|
|Subject: Re: RANDOM function?|
|Previous:||From: macky||Date: 2001-07-31 05:41:43|
|Subject: RANDOM function?|