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?.
version
PostgreSQL 12.0 (Debian 12.0-1.pgdg90+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit
4 rows affected
party_id party_name
1 Bill
2 Fred
3 Mary
4 Jim
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
t_id party_id party_name action party_name a item t_amount
1 1 Bill  sold to Fred  a Car 45
2 2 Fred  sold to Mary  a Car 50
3 2 Fred  sold to Jim  a Ship 450
4 4 Jim  sold to Bill  a Ship 500
5 3 Mary  sold to Fred  a Book 5
6 2 Fred  sold to Jim  a Book 7
7 3 Mary  sold to Bill  a TV 60
8 1 Bill  sold to Fred  a TV 70