add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
7 rows affected
7 rows affected
name reportday val1 val2 name reportday test1 test2
A 2022-04-05 1 2 null null null null
B 2022-04-05 3 4 B 2022-04-05 11 22
C 2022-04-05 5 6 C 2022-04-05 33 44
null null null null D 2022-04-05 55 66
name reportday val1 val2 name reportday test1 test2
A 2022-04-05 1 2 null null null null
B 2022-04-05 3 4 B 2022-04-05 11 22
C 2022-04-05 5 6 C 2022-04-05 33 44
null null null null D 2022-04-05 55 66