By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 5
| id | rt1 | rt2 | new_rt_column |
|---|---|---|---|
| a | 0.345 | null | 0.345 |
| b | 0.00 | 0.345 | 0.345 |
| c | 0.00 | 0.00 | null |
| d | 0.00 | null | null |
| e | null | 0.00 | null |
SELECT 5
CREATE TABLE
INSERT 0 5
| id | rt1 | rt2 | new_rt_column |
|---|---|---|---|
| a | 0.345 | null | 0.345 |
| b | 0.00 | 0.345 | 0.345 |
| c | 0.00 | 0.00 | null |
| d | 0.00 | null | null |
| e | null | 0.00 | null |
SELECT 5