| Subject | Re: how to swap two values on a uniquely constrained column? |
|---|---|
| Author | woodsmailbox |
| Post date | 2009-03-14T17:59:08Z |
--- In firebird-support@yahoogroups.com, 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.
>