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?.
CREATE TABLE
badge l1_mgr_id l2_mgr_id l3_mgr_id l4_mgr_id l1_mgr_name l2_mgr_name l3_mgr_name l4_mgr_name cost_center
12 888 777 666 555 A B C D 123
666 444 333 222 111 E F G H 125
555 900 800 700 600 I J K L 127
222 38 48 58 68 N O P Q 123
111 90 110 130 150 R S T U 126 
INSERT 0 5

CREATE TABLE
cost_center domain
123 workplace
125 PI
127 space
126 blockchain 
INSERT 0 4
l3_mgr_id l3_mgr_name l3_cost_center l4_mgr_id l4_mgr_name l4_cost_center
222 P workplace 111 U blockchain
666 G PI 555 L space 
SELECT 2