> Hi all, > > Is there a way to move a cursor in plpgsql in the same way as in > regular sql? The function below would like to move the cursor back to > the start each time the cursor runs out of rows, creating pairs of > integers that are randomly put together. > > The "motivation" for this is to randomly assign parts of a > shakespearian play (N=25) to not enough actors (N=6), giving each > actor several parts. (To be truly fair, I would have to weight by > number of lines, but that is for version 2... ) If there is a more > graceful way to solve the problem, I am interested, but I would like > to know about the MOVE issue in any case. Wouldn't it be easier to list the parts in a random order (simply ORDER BY RANDOM()) and then use modulo by number of actors (but there's no ROWNUM so a loop is needed anyway). Something like i := 0; FOR x IN SELECT .... parts ... LOOP actor := mod(i,number_of_actors); i := i + 1; END LOOP; This should be fair enough and does not need moving the cursors in various areas. t.v.
