By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
12 rows affected
| product | switch | switchday | next_switch_1 | next_switch_2 |
|---|---|---|---|---|
| a | 0 | 2020-01-01 | 0 | 1 |
| a | 0 | 2020-01-02 | 1 | 0 |
| a | 0 | 2020-01-06 | 0 | 1 |
| a | 0 | 2020-01-07 | 1 | 1 |
| b | 0 | 2020-01-02 | 0 | 1 |
| b | 0 | 2020-01-03 | 1 | null |