John R Pierce <pierce@xxxxxxxxxxxx> writes: > ries van Twisk wrote: >> 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 Nah, ries is correct. Think of it this way: one-third of the time the first WHEN succeeds, and you get '1'. In *half of the remaining cases*, you want '2', so the second test should be against 0.5. > but... wouldn't floor(random() * 3.0) + 1 be a simpler way to do this? Agreed... regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
