Thank you. I have thought about that possibility, but it is good to know it is used. In the previous example of moving id 98 to position 2, I think I would need something like this: UPDATE example SET pos = (SELECT MAX(pos)+0.001) WHERE pos < 3; Correct me if I am wrong or if there is a better way.