|Subject||Re: how to swap two values on a uniquely constrained column?|
--- In firstname.lastname@example.org, Dimitry Sibiryakov <sd@...> wrote:
>Obviously to preserve the custom ordering. Two rows of same ORDER_INDEX don't have a definite order.
> > For example, the ORDER_INDEX column is used for custom ordering of values. I want to be able to move a row's position in the dataset updating that column.
> But why such column must be unique?
> SY, SD.