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?.
9 rows affected
campaign expected_inbound_date expected_inbound_quantity received_inbound_quantity split
C001 2022-05-03 200 0 200
C001 2022-05-03 400 0 400
C001 2022-05-03 500 0 100
C001 2022-05-03 800 0 0
C001 null 0 700 0
C002 2022-08-20 2800 0 2800
C002 2022-08-20 3000 0 1200
C002 2022-08-20 5000 0 0
C002 null 0 4000 0