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

[John R Pierce <pierce@xxxxxxxxxxxx>]

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?







--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general