Skip site navigation (1) Skip section navigation (2)

Re: RANDOM function?

From: "macky" <macky(at)edsamail(dot)com>
To: "Einar Karttunen" <ekarttun(at)cs(dot)Helsinki(dot)FI>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: RANDOM function?
Date: 2001-07-31 05:55:28
Message-ID: 00d101c11985$672ad690$5764a8c0@edsamail.com (view raw or flat)
Thread:
Lists: pgsql-novice
if ill be using big range of numbers sa 10000 woundd the be any possibility
to have multiple items... meaning lets say 1234 will show up more than once?
----------------------------------------------------------------------
The information contained in this message (including any attachments)
is confidential and intended solely for the attention and use of the
named addressee(s). It must not be copied, distributed nor disclosed
to any person. If you are not the intended recipient, please delete
it from your system and notify sender immediately. Any disclosure,
copying or distribution thereof or any action taken or omitted to be
taken in reliance thereon is prohibited and may be unlawful.
----------------------------------------------------------------------

----- Original Message -----
From: "Einar Karttunen" <ekarttun(at)cs(dot)Helsinki(dot)FI>
To: "macky" <macky(at)edsamail(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Sent: Tuesday, July 31, 2001 1:50 PM
Subject: 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
>
>
>


In response to

Responses

pgsql-novice by date

Next:From: Einar KarttunenDate: 2001-07-31 06:09:27
Subject: Re: RANDOM function?
Previous:From: Einar KarttunenDate: 2001-07-31 05:50:53
Subject: Re: RANDOM function?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group