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

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 (view raw or flat)
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

pgsql-novice by date

Next:From: ghaverlaDate: 2001-07-31 11:53:36
Subject: Re: Re: RANDOM function?
Previous:From: mackyDate: 2001-07-31 05:55:28
Subject: Re: RANDOM function?

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