Re: Still wondering about random numbers...
John Gateley <gateley@jriver.com>
From: gateley@jriver.com
To: Joe Conway <joseph.conway@home.com>
Cc: "Dr. Evil" <drevil@sidereal.kz>, pgsql-general@postgresql.org
Date: 2001-08-07T16:41:36Z
Lists: pgsql-general
Joe Conway wrote: > > > I am running on OpenBSD and Linux, both of which have > > cryptographic-quality RNGs built in. When I call RANDOM() in PG, do I > > get the old C library random numbers, which are not very random, or do > > I get high-quality random numbers from the crypto-RNG that's built in? > > Any sugestions for getting high-quality random numbers? > > Looking through the source, I find: > result = ((double) random()) / ((double) MAX_RANDOM_VALUE); The random() function returns better (good?) random numbers. The rand() function returns poor random numbers. random() also depends on how much state it is initialized with (and may or may not be based on /dev/random, I don't know). j