Subject Re: [firebird-support] how to swap two values on a uniquely constrained column?
Author Milan Babuskov
woodsmailbox wrote:
> I know deferred constraints would solve it, but is there any other way in the absence of it? Assigning an out-of-domain value is not acceptable, since it breaks the domain definition. Thanks.

Maybe you could swap (update) values of all other columns and leave the
unique column as it is?

Milan Babuskov