The trigger is a nice idea, but renumbering the index won't work, since the index might be used as a key to link the record to another table.. I guess I could use a new index, just for this purpose but that seems to be a waste of resources..
How do you renumber an index anyway? Randall Fox On Thu, 22 Jul 2004 11:19:52 +0200, you wrote: > >> I am just wondering if it was done or there is an easy way.. > >As suggested by Kurt, given a subsequent index from idx = 1 ... N, you may > use color = idx%2 to compute your color. > >To work around the problem of insert/delete, I'd try to employ a trigger on >these events to renumber the index (idx) first and then recompute the colors. > >Cheers > Daniel