Re: RANDOM function? - Mailing list pgsql-novice

From Einar Karttunen
Subject Re: RANDOM function?
Date
Msg-id Pine.LNX.4.33.0107310904130.17036-100000@melkinpaasi.cs.Helsinki.FI
Whole thread Raw
In response to Re: RANDOM function?  ("macky" <macky@edsamail.com>)
List pgsql-novice
On Tue, 31 Jul 2001, macky wrote:

> 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?
Yes it is possible. The probablity is 1/10000. Just multiply it with a
large number. I suggest 2147483647 if you want to get all the non-negative
numbers possible for an int4 value.

- Einar Karttunen



pgsql-novice by date:

Previous
From: "macky"
Date:
Subject: Re: RANDOM function?
Next
From: ghaverla@freenet.edmonton.ab.ca
Date:
Subject: Re: Re: RANDOM function?