SQLize Online / PHPize Online  /  SQLtest Online

create table t (id int not null generated always as identity, val1 int, val2 int); create unique index t_ux_vals on t (val1, val2); create unique index t_ux_val1_null on t (val1) where val1 is not null and val2 is null; create unique index t_ux_val2_null on t (val2) where val2 is not null and val1 is null; insert into t (val1, val2) values (0, 0); insert into t (val1, val2) values (0, null); insert into t (val1, val2) values (1, null); insert into t (val1, val2) values (null, 0); insert into t (val1, val2) values (null, 1); insert into t (val1, val2) values (null, null); insert into t (val1, val2) values (0, 0); insert into t (val1, val2) values (0, null); insert into t (val1, val2) values (null, 0); insert into t (val1, val2) values (null, null); select * from t;