Re: Random()

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Random()
Date: 2006-11-16 21:20:38
Message-ID: 20061116212038.GB16916@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, Nov 16, 2006 at 06:54:42PM -0200, Ezequias Rodrigues da Rocha wrote:
> My bigint field has 20,000 numbers and I'd like to make real random (used
> like lottery).

If you want _real_ random, you have to use a non-computer source for
your randomness. The best you get on a computer is pseudo-random.
Often it's very good pseudo-random -- most of the time, good enough
for most purposes -- but it isn't true randomness of the sort that is
delivered by (for example) particle decay.

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
The plural of anecdote is not data.
--Roger Brinner

In response to

  • Re: Random() at 2006-11-16 20:54:42 from Ezequias Rodrigues da Rocha

Browse pgsql-sql by date

  From Date Subject
Next Message Joe 2006-11-16 22:23:44 Re: Question about time
Previous Message Ezequias Rodrigues da Rocha 2006-11-16 20:54:42 Re: Random()