Re: RANDOM function?

From: Einar Karttunen <ekarttun(at)cs(dot)Helsinki(dot)FI>
To: macky <macky(at)edsamail(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: RANDOM function?
Date: 2001-07-31 06:09:27
Message-ID: Pine.LNX.4.33.0107310904130.17036-100000@melkinpaasi.cs.Helsinki.FI
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message ghaverla 2001-07-31 11:53:36 Re: Re: RANDOM function?
Previous Message macky 2001-07-31 05:55:28 Re: RANDOM function?