Comment detail

n人中m人が当選するくじ (Nested Flatten)
PostgreSQL以外はよく知りませんが。
1
2
3
4
5
6
7
=# create function lot(int, int) returns setof int as $$
  select * from generate_series(1, $1) order by random() limit $2;
$$ language sql;
=# select * from lot(10, 3);

普通は関数作るまでもなく、
=# select * from generate_series(1, 10) order by random() limit 3;

Index

Feed

Other

Link

Pathtraq

loading...