[Fwd: Re: surprising results with random()]

ries van Twisk wrote:

>
> Jessi,
>
> should the function not look like this???
>
> CREATE OR REPLACE VIEW test_view AS
> SELECT
>     CASE
>         WHEN random() < .333333333 THEN '1'
>         WHEN random() < .5 THEN '2'
>         ELSE '3'
>     END AS test_value
>
> FROM client;


actually, I'd think that should be .66666


but... wouldn't    floor(random() * 3.0) + 1  be a simpler way to do this?