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?.
24 rows affected
id prod_id year quarter start_flag end_flag
1 A001 2015 1 0 0
2 A001 2015 2 1 0
3 A001 2015 3 0 0
4 A001 2015 4 0 0
5 A001 2016 1 0 0
6 A001 2016 2 0 0
7 A001 2016 3 0 1
8 A001 2016 4 0 0
9 B002 2015 1 0 0
10 B002 2015 2 0 0
11 B002 2015 3 0 0
12 B002 2015 4 1 0
13 B002 2016 1 0 1
14 B002 2016 2 0 0
15 B002 2016 3 0 0
16 B002 2016 4 0 0
17 C003 2015 1 0 1
18 C003 2015 2 0 0
19 C003 2015 3 0 1
20 C003 2015 4 1 0
21 C003 2016 1 0 0
22 C003 2016 2 0 0
23 C003 2016 3 0 0
24 C003 2016 4 0 0
id prod_id year quarter start_flag end_flag sum status
1 A001 2015 1 0 0 0 0
2 A001 2015 2 1 0 1 1
3 A001 2015 3 0 0 1 1
4 A001 2015 4 0 0 1 1
5 A001 2016 1 0 0 1 1
6 A001 2016 2 0 0 1 1
7 A001 2016 3 0 1 2 0
8 A001 2016 4 0 0 2 0
9 B002 2015 1 0 0 0 0
10 B002 2015 2 0 0 0 0
11 B002 2015 3 0 0 0 0
12 B002 2015 4 1 0 1 1
13 B002 2016 1 0 1 2 0
14 B002 2016 2 0 0 2 0
15 B002 2016 3 0 0 2 0
16 B002 2016 4 0 0 2 0
17 C003 2015 1 0 1 1 0
18 C003 2015 2 0 0 1 0
19 C003 2015 3 0 1 2 0
20 C003 2015 4 1 0 3 1
21 C003 2016 1 0 0 3 1
22 C003 2016 2 0 0 3 1
23 C003 2016 3 0 0 3 1
24 C003 2016 4 0 0 3 1