> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
