> Is there a way to move a cursor in plpgsql in the same way as in > regular sql? ... 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 think you are right Thomas about the modulo, and that might be even better stylistically (more obvious to the reader) -- thanks! I still wonder if MOVing cursor in plpgsql is impossible, possible, or available soon? Thanks again, W
