By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| val | datatype1 | datatype2 | datatype3 | datatype4 |
|---|---|---|---|---|
| 4 | 0 | 0 | 1 | 0 |
| 10 | 1 | 0 | 0 | 0 |
| 20 | 1 | 0 | 0 | 0 |
| 30 | 1 | 0 | 0 | 0 |
| 31 | 1 | 1 | 1 | 0 |
8 rows affected
| val | datatype1 | datatype2 | datatype3 | datatype4 |
|---|---|---|---|---|
| 4 | 0 | 0 | 1 | 0 |
| 10 | 1 | 0 | 0 | 0 |
| 20 | 1 | 0 | 0 | 0 |
| 30 | 1 | 0 | 0 | 0 |
| 31 | 1 | 1 | 1 | 0 |