Re: [GENERAL] Re: [HACKERS] random() function produces wrong range

2000-08-03 Thread Roland Roberts
-BEGIN PGP SIGNED MESSAGE- > "Tom" == Tom Lane <[EMAIL PROTECTED]> writes: Tom> Actually the odds are far better than that. If the range is Tom> 2^31-1 then only about 2^-16th of the outputs should be less Tom> than 2^15. So ten probes gives you a failure probability of

Re: [GENERAL] Re: [HACKERS] random() function produces wrong range

2000-08-03 Thread Tom Lane
Roland Roberts <[EMAIL PROTECTED]> writes: > Call random() several times and test the maximum value against your > thresholds of 2^15 and 2^31. If random() is generating values in the > range 1:2^31-1, you would expect half of your values to be greater > than 2^15-1; more importantly, if you gene