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
INSERT 0 7
levelindex boqitemname sitename
1 First things first null
1.1 First of first things null
1.1.1 Clamp null
1.1.1.1 Hand Clamp null
1.1.1.2 Door Clamp null
1.1.2 Switches null
1.1.2.1 Two way switch null
SELECT 7
UPDATE 7
levelindex boqitemname sitename
1 First things first null
1.1 First of first things First things first
1.1.1 Clamp First of first things
1.1.1.1 Hand Clamp Clamp
1.1.1.2 Door Clamp Clamp
1.1.2 Switches First of first things
1.1.2.1 Two way switch Switches
SELECT 7
UPDATE 7
levelindex boqitemname sitename
1 First things first First things first
1.1 First of first things First things first
1.1.1 Clamp First of first things
1.1.1.1 Hand Clamp Clamp
1.1.1.2 Door Clamp Clamp
1.1.2 Switches First of first things
1.1.2.1 Two way switch Switches
SELECT 7