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
CREATE TABLE
CREATE TABLE
INSERT 0 4
INSERT 0 5
INSERT 0 10
container_with_things
{"id":"1","name":"one","location":"here","thingIds":["1", "2", "3"]}
{"id":"3","name":"three","location":"somewhere","thingIds":["1", "2", "3", "4", "5"]}
{"id":"4","name":"4 is empty","location":"void","thingIds":[null]}
SELECT 3
container_with_things
{"id":"1","name":"one","location":"here","thingIds":["1", "2", "3"]}
{"id":"3","name":"three","location":"somewhere","thingIds":["1", "2", "3", "4", "5"]}
{"id":"4","name":"4 is empty","location":"void","thingIds":null}
SELECT 3
container_with_things
{"id":"1","name":"one","location":"here","thingIds":["1","2","3"]}
{"id":"3","name":"three","location":"somewhere","thingIds":["1","2","3","4","5"]}
{"id":"4","name":"4 is empty","location":"void","thingIds":[]}
SELECT 3
container_with_things
{"id": "1", "name": "one", "location": "here", "thingIds": ["1", "2", "3"]}
{"id": "3", "name": "three", "location": "somewhere", "thingIds": ["1", "2", "3", "4", "5"]}
{"id": "4", "name": "4 is empty", "location": "void", "thingIds": []}
SELECT 3
container_with_things
{"id": "1", "name": "one", "location": "here", "thingIds": ["1", "2", "3"]}
{"id": "3", "name": "three", "location": "somewhere", "thingIds": ["1", "2", "3", "4", "5"]}
{"id": "4", "name": "4 is empty", "location": "void", "thingIds": null}
SELECT 3