Subject Re: [firebird-support] Re: how to swap two values on a uniquely constrained column?
Author Dimitry Sibiryakov
> Obviously to preserve the custom ordering. Two rows of same ORDER_INDEX don't have a definite order.

But how they can get the same value if you handle ORDER_INDEX properly?
I mean that unique constraints are supposed to prevent serious data
problems. Custom ordering isn't critical enough.