By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE t0 (c0 BIT, c1 FLOAT);
INSERT INTO t0 VALUES (1, 6.26034297557673e+37);
SELECT (NULLIF(t0.c0, t0.c1)) AS c0 FROM t0;
| c0 |
|---|
| 49 |
CREATE TABLE t1 AS (SELECT (NULLIF(t0.c0, t0.c1)) AS c0 FROM t0);
Records: 1 Duplicates: 0 Warnings: 0
SELECT * FROM t1;
| c0 |
|---|
| 1 |