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?.
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
id_product name_product ingredient_id product_id_comp level_blend last_comp_blend compact_flat_view
1 milk 1A 1 t CF
2 flour 2A 1 t CF
3 egs 3A 1 t CF
4 sugar 4A 1 t CF
5 salt 5A 1 t CF
8 bakingsoda 8A 1 t CF
6 cakeA 1A 1B 1 t CF
6 cakeA 6A 5A 1 f C
6 cakeA 6A 1A 1 f C
6 cakeA 6B 2A 1 f C
7 cakeB 7A 2A 1 f C
7 cakeB 7B 8A 1 f C
7 cakeB 7C 3A 1 f C
5 cakeA 6A 2 t F
6 cakeA 6A 1B 2 t F
1 cakeA 6A 2 t F
2 cakeA 6B 2 t F
2 cakeB 7A 2 t F
8 cakeB 7B 2 t F
3 cakeB 7C 2 t F