godfat

WITH RECURSIVE results(id, i, picked, roll) AS (
  WITH bounds AS (SELECT min(id), max(id) - min(id) AS delta FROM table)
  (
    SELECT NULL::integer
    ,      0
    ,      ARRAY[]::integer[]
    ,      min + round(delta * random())
      FROM bounds
  )
  UNION ALL