Postgres 18

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table franck ( val int unique DEFERRABLE INITIALLY DEFERRED );

CREATE TABLE

insert into franck values (-1),(1) ;

INSERT 0 2

select val from franck;

val

-1

1

SELECT 2

update franck set val=-val;

UPDATE 2

select val from franck;

val

1

-1

SELECT 2