Horton

Re: RANDOM function?

Einar Karttunen <ekarttun@cs.helsinki.fi>

View thread View on postgr.es
From: Einar Karttunen <ekarttun@cs.Helsinki.FI>
To: macky <macky@edsamail.com>
Cc: <pgsql-novice@postgresql.org>
Date: 2001-07-31T06:09:27Z
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